One of the questions asked during my recent presentation at the PASS Community summit was how to execute a script that is contained in a file using SMO. Unfortunately we ran out of time to answer this question during the session. So below is a VB.Net code snippet that can be used to execute a SQL Script using SMO:
Dim sr As StreamReader = New StreamReader(“C:\script.sql”)
Dim script As String = sr.ReadToEnd
Dim SMOServer As Server = New Server
Dim db As Database = SMOServer.Databases(“northwind”)
db.ExecuteNonQuery(script)
