如何使用vb.net生成Sql Database脚本 [英] How to generate Sql Database script using vb.net

问题描述

我想生成sqlscript并使用vb.net运行sqlscript任何人都可以告诉我如何执行此操作我使用以下代码但他给我错误：无法连接到服务器..）

I want generate sqlscript and run sqlscript using vb.net any one can tell me how to do this i am using following code but he give me error: Failed to connect to server ..)

Dim tableFileName As String = "D:\PharmaDbScript.sql"
Dim tableText As String
Dim srvMgmtServer As Server = New Server
Dim srvConn As ServerConnection
Dim osqlservers As String = oSQLConnection.ToString

Dim objDB As Database = srvMgmtServer.Databases(osqlservers)
srvConn = srvMgmtServer.ConnectionContext
srvConn.ServerInstance = SQLServer
srvConn.LoginSecure = False
If srvConn.LoginSecure = False Then
   srvConn.Login = "id"
   srvConn.Password = "password"
End If

Using FileReader As New Microsoft.VisualBasic.FileIO.TextFieldParser(tableFileName)
   tableText = FileReader.ReadToEnd
End Using

If tableText <> "" Then
   objDB.ExecuteNonQuery(tableText)
End If

推荐答案

请阅读 http://www.codeproject.com/Messages/1501657/How-to-Execute-sql-script-in-vb-net.aspx [ ^ ]

< br>

尝试 http：/ /jai-on-asp.blogspot.in/2010/06/running-sql-script-file-from-net-code.html [ ^ ]。

这篇关于如何使用vb.net生成Sql Database脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！