C#调用SQLCMD去批量执行sql脚本

最新推荐文章于 2020-12-08 19:00:34 发布

CodingSir

最新推荐文章于 2020-12-08 19:00:34 发布

阅读量4.2k

点赞数

文章标签： c# sql string 脚本 user

本文链接：https://blog.csdn.net/educast/article/details/6132789

版权

string tmpFile = Path.GetTempFileName();

string argument = string.Format(@" -S {0} -d {1} -i ""{2}"" -o ""{3}""",
    ServerName, DatabaseName, fileName, tmpFile);

// append user/password if not use integrated security
if (!connection.IsIntegratedSecurity)
    argument += string.Format(" -U {0} -P {1}", User, Password);

var process = Process.Start("sqlcmd.exe", argument);
process.StartInfo.UseShellExecute = false;
process.StartInfo.CreateNoWindow = true;
process.Start();
while (true)
{
    // wait for the process exits. The WaitForExit() method doesn't work
    if (process.HasExited)
        break;
    Thread.Sleep(500);
}