在C#中用SQLDMO创建SQL数据库
SQLDMO.Database nDB = new SQLDMO.Database(); SQLDMO.DBFile nDBFile = new SQLDMO.DBFile();SQLDMO.LogFile nLogFile = new SQLDMO.LogFile();
nDB.Name = dbName;
nDBFile.Name = dbName + "file";
nDBFile.PhysicalName = dbPath + "_Data.mdf";
nDBFile.PrimaryFile = true;
nDBFile.FileGrowthType = 0;
nDBFile.FileGrowth = 1;
nDB.FileGroups.Item("primary").DBFiles.Add(nDBFile);
nLogFile.Name = dbName + "log";
nLogFile.PhysicalName = dbPath + "_Log.ldf";
nDB.TransactionLog.LogFiles.Add(nLogFile);
srv.Databases.Add(nDB);
srv.Close();
sqlApp.Quit();
return rvCDB;
}
SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass();
SQLDMO.SQLServer srv = new SQLDMO.SQLServerClass();
srv.Connect("servername", "username", "password");
SQLDMO.Database nDB = new SQLDMO.Database();
SQLDMO.DBFile nDBFile = new SQLDMO.DBFile();
SQLDMO.LogFile nLogFile = new SQLDMO.LogFile();
nDB.Name = "tmpdb"; //数据库名
nDBFile.Name = "tmpfile"; //数据库文件名
nDBFile.PhysicalName = @"e:\temp\tmp.mdf"; //数据库文件在硬盘上存储的实际名称
nDBFile.PrimaryFile = true;
nDBFile.FileGrowthType = 0;
nDBFile.FileGrowth = 1;
nDB.FileGroups.Item("primary").DBFiles.Add(nDBFile);
nLogFile.Name = "tmplg";
nLogFile.PhysicalName = @"e:\temp\tmp.ldf";
nDB.TransactionLog.LogFiles.Add(nLogFile);
srv.Databases.Add(nDB);
srv.Close();
sqlApp.Quit();
页:
[1]