如何使用Windows应用程序将sql数据库上载到在线服务器
问题描述：
如何使用Windows应用程序将本地数据库(SQL Server 2005)上载到联机服务器(SQL Server 2005/2008)中.
how to upload local database (sql server 2005) to online server (sql server 2005/2008) using windows application
答
ServerConnection conn = new ServerConnection("rune\\sql2008");
Server server = new Server(conn);
Database newdb = new Database(server, "new database");
newdb.Create();
Transfer transfer = new Transfer(server.Databases["source database"]);
transfer.CopyAllObjects = true;
transfer.CopyAllUsers = true;
transfer.Options.WithDependencies = true;
transfer.DestinationDatabase = newdb.Name;
transfer.DestinationServer = server.Name;
transfer.DestinationLoginSecure = true;
transfer.CopySchema = true;
transfer.CopyData = true;
transfer.Options.ContinueScriptingOnError = true;
transfer.TransferData();
有关SMO名称空间的更多信息:
SMO-管理您的SQL Server！ [
For more info on SMO namespace:
SMO - Manage your SQL Server![^]