SQLDEMO

最新推荐文章于 2024-03-28 08:30:00 发布

zwei1121

最新推荐文章于 2024-03-28 08:30:00 发布

阅读量1.3k

点赞数

分类专栏： Sql Server 文章标签： sqlserver 服务器 database 数据库 sql null

本文链接：https://blog.csdn.net/zwei1121/article/details/660754

版权

Sql Server 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

privatevoidButton3_Click(objectsender,System.EventArgse)
{
//引用SQLDMO.dll，SQLDMO由MicrosoftSQLServer自带的SQLDMO.dll提供，SQLDMO.dll是一个COM对象
SQLDMO.Backupbackup=newSQLDMO.BackupClass();17:29 2006-4-12
SQLDMO.SQLServersqlserver=newSQLDMO.SQLServerClass();
sqlserver.LoginSecure=false;
sqlserver.Connect("localhost","sa","1");
backup.Action=SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
backup.Database="userdb";zz
backup.Files=@"E:/Project/meng/data/userdb.bak";
backup.BackupSetName="userdb";
backup.BackupSetDescription="数据库备份";
backup.Initialize=true;
backup.SQLBackup(sqlserver);
}

privatevoidButton4_Click(objectsender,System.EventArgse)
{
SQLDMO.Restorerestore=newSQLDMO.RestoreClass();
SQLDMO.SQLServersqlserver=newSQLDMO.SQLServerClass();
sqlserver.LoginSecure=false;
sqlserver.Connect("192.168.19.25","sa","sa");restore.Action=SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
restore.Database="userdb";
restore.Files=@"E:/Project/meng/data/userdb.bak";
restore.BackupSetName="userdb";
restore.FileNumber=1;
restore.SQLRestore(sqlserver);
}
//得到指定SQL服务器所有数据库的列表
publicArrayListGetDataBaseList(stringServerName,stringUserName,stringPwd)
{
ArrayListlist=newArrayList();
SQLDMO.ApplicationsqlApp=newSQLDMO.Application();
SQLDMO.SQLServeroServer=newSQLDMO.SQLServer();

oServer.Connect(ServerName,UserName,Pwd);
foreach(SQLDMO.DatabasedbinoServer.Databases)
{
if((db.Name!=null)&&(db.SystemObject==false))
list.Add(db.Name);
}
returnlist;
}

//得到SQL服务器的列表
publicArrayListGetSqlServerList()
{
ArrayListlist=newArrayList();
SQLDMO.ApplicationsqlApp=newSQLDMO.Application();
SQLDMO.NameListServerName=sqlApp.ListAvailableSQLServers();
for(inti=0;i<ServerName.Count;i++)
{
list.Add(ServerName.Item(i+1));
}
returnlist;
}

//得到指定SQL服务器所有数据库的列表
publicArrayListGetDataBaseList(stringServerName,stringUserName,stringPwd)
{
ArrayListlist=newArrayList();
SQLDMO.ApplicationsqlApp=newSQLDMO.Application();
SQLDMO.SQLServeroServer=newSQLDMO.SQLServer();

oServer.Connect(ServerName,UserName,Pwd);
foreach(SQLDMO.DatabasedbinoServer.Databases)
{
if((db.Name!=null)&&(db.SystemObject==false))
list.Add(db.Name);
}
returnlist;
}