SQLDMO.SQLServer2 sqlserver
=
new
SQLDMO.SQLServer2Class();
sqlserver.Connect( " localhost " , " sa " , "" );
SQLDMO.Databases mydbs = sqlserver.Databases;
SQLDMO.Database mydb = new SQLDMO.DatabaseClass ();
mydb = (SQLDMO.Database)mydbs.Item( " Test " , " sa " );
System.IO.StreamReader s = new System.IO.StreamReader( " E:/xp/testSqlDmo/a.sql " );
string sql = s.ReadToEnd();
mydb.ExecuteImmediate(sql,SQLDMO.SQLDMO_EXEC_TYPE.SQLDMOExec_Default,sql.Length );
sqlserver.Connect( " localhost " , " sa " , "" );
SQLDMO.Databases mydbs = sqlserver.Databases;
SQLDMO.Database mydb = new SQLDMO.DatabaseClass ();
mydb = (SQLDMO.Database)mydbs.Item( " Test " , " sa " );
System.IO.StreamReader s = new System.IO.StreamReader( " E:/xp/testSqlDmo/a.sql " );
string sql = s.ReadToEnd();
mydb.ExecuteImmediate(sql,SQLDMO.SQLDMO_EXEC_TYPE.SQLDMOExec_Default,sql.Length );