使用Azure Powershell执行.sql文件

我已经看过从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？

谢谢.

解决方法

$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()

（编辑：安卓应用网）

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