ExecuteSqlScripts – Executing an array of script files

' Execute an array of sql script files with batch statements,'  by using the same SqlCommand object'  - connString is the connection string for the destination database'' Example:'   Dim connString As String = "server=(local);Persist Security ' Info=False;Integrated Security=SSPI;database=TestDB"'   Dim script1 As String = "C:ScriptsCreateDbTables.sql"'   Dim script2 As String = "C:ScriptsCreateDbSprocs.sql"'   Dim script3 As String = "C:ScriptsInsertData.sql"'   ExecuteSqlScripts(connString, script1, script2, script3)Sub ExecuteSqlScripts(ByVal connString As String, ByVal ParamArray scriptFiles() _    As String)    ' open the connection and create a command that uses it    Dim cn As New SqlConnection(connString)    Dim cmd As New SqlCommand    Try        cn.Open()        cmd.Connection = cn        Dim scriptFile As String        For Each scriptFile In scriptFiles            ' get the content of the script file            Dim sr As System.IO.StreamReader = Nothing            Try                sr = New System.IO.StreamReader(scriptFile)                ' use the script file's content as CommandText for the command                 ' created above                cmd.CommandText = sr.ReadToEnd()            Catch ex As Exception                Throw ex            Finally                If Not sr Is Nothing Then sr.Close()            End Try            ' execute this script            cmd.ExecuteNonQuery()        Next    Catch ex As Exception        Throw ex    Finally        cn.Close()    End TryEnd Sub

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


The Latest

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS

homes in the real estate industry

Exploring the Latest Tech Trends Impacting the Real Estate Industry

The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may