我已经看过从Azure Power
shell运行sql命令的示例,例如
@H_502_2@$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分钟,我发现了它.
@H_502_2@$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()
