使用Azure Powershell执行.sql文件

发布时间：2020-12-12 08:54:06 所属栏目：MsSql教程来源：网络整理

导读：我已经看过从Azure Power shell运行SQL命令的示例,例如 $connectionString = "Data Source=MyDataSource;Initial Catalog=MyDB;User ID=user1;Password=pass1;Connection Timeout=90"$connection = New-Object -TypeName System.Data.SqlClient.SqlConnection

我已经看过从Azure Power shell运行SQL命令的示例,例如

$connectionString = "Data Source=MyDataSource;Initial Catalog=MyDB;User ID=user1;Password=pass1;Connection Timeout=90"
$connection = New-Object -TypeName System.Data.SqlClient.SqlConnection($connectionString)
$query = "CREATE TABLE...." 
$command = New-Object -TypeName System.Data.SqlClient.SqlCommand($query,$connection)
$connection.Open()
$command.ExecuteNonQuery()
$connection.Close()

有没有办法用引用包含整个SQL脚本的外部文件替换$query？

谢谢.

解决方法

再搜索20分钟,我发现了它.

$connectionString = "Data Source=MyDataSource;Initial Catalog=MyDB;User ID=user1;Password=pass1;Connection Timeout=90"
$connection = New-Object -TypeName System.Data.SqlClient.SqlConnection($connectionString)
$query = [IO.File]::ReadAllText("C:...TestSQL.sql")
$command = New-Object -TypeName System.Data.SqlClient.SqlCommand($query,$connection)
$connection.Open()
$command.ExecuteNonQuery()
$connection.Close()

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!