Builder中,sqlserver在客户端调用存储过程向服务器端备份
来源:互联网 发布:甲子网络 刘荣祥 编辑:程序博客网 时间:2024/06/04 18:13
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
1.Createabackupdatabasestoredprocedureinmasterdatabase.
CREATEPROCEDUREbackupdb
@databasevarchar(10),
@directoryvarchar(100)
AS
backupdatabase@database
todisk=@directory
2.Getpathof.
AnsiString__fastcallTFrmDM::GetsqlserverPath(){
AnsiStringresult,tmp;
TADOQuery*Query=newTADOQuery(this);
Query->Connection=ADOConnection_Master;
Query->Close();
Query->SQL->Clear();
Query->SQL->Add("selectfilenamefromsysdatabaseswherename='master'");
Query->Open();
tmp=Query->FieldByName("filename")->AsString;
result=tmp.SubString(1,tmp.Length()-15);
Query->Free();
returnresult;
}
3.Callthebackupdatabasestoredprocedure.
d=FormatDateTime("yyyy-mm-ddhh-mm-ss",FrmDM->GetServerTime());
try{
path=FrmDM->GetsqlserverPath()+"backup//";
FrmDM->ADOStoredProc1->Close();
FrmDM->ADOStoredProc1->Connection=FrmDM->ADOConnection_Master;
FrmDM->ADOStoredProc1->Prepared=true;
FrmDM->ADOStoredProc1->ProcedureName="backupdb;1";
FrmDM->ADOStoredProc1->Parameters->ParamByName("@database")->Value="db_name_to_backup";
FrmDM->ADOStoredProc1->Parameters->ParamByName("@directory")->Value=path+"db_name_to_backup"+d;
FrmDM->ADOStoredProc1->ExecProc();
Application->MessageBox("备份完成","提示",MB_OK+MB_ICONINFORMATION);
this->Close();
}
catch(...){
Application->MessageBox("备份出错,请重新再来","警告",MB_OK+MB_ICONWARNING);
return;
}
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
1.Createabackupdatabasestoredprocedureinmasterdatabase.
CREATEPROCEDUREbackupdb
@databasevarchar(10),
@directoryvarchar(100)
AS
backupdatabase@database
todisk=@directory
2.Getpathof.
AnsiString__fastcallTFrmDM::GetsqlserverPath(){
AnsiStringresult,tmp;
TADOQuery*Query=newTADOQuery(this);
Query->Connection=ADOConnection_Master;
Query->Close();
Query->SQL->Clear();
Query->SQL->Add("selectfilenamefromsysdatabaseswherename='master'");
Query->Open();
tmp=Query->FieldByName("filename")->AsString;
result=tmp.SubString(1,tmp.Length()-15);
Query->Free();
returnresult;
}
3.Callthebackupdatabasestoredprocedure.
d=FormatDateTime("yyyy-mm-ddhh-mm-ss",FrmDM->GetServerTime());
try{
path=FrmDM->GetsqlserverPath()+"backup//";
FrmDM->ADOStoredProc1->Close();
FrmDM->ADOStoredProc1->Connection=FrmDM->ADOConnection_Master;
FrmDM->ADOStoredProc1->Prepared=true;
FrmDM->ADOStoredProc1->ProcedureName="backupdb;1";
FrmDM->ADOStoredProc1->Parameters->ParamByName("@database")->Value="db_name_to_backup";
FrmDM->ADOStoredProc1->Parameters->ParamByName("@directory")->Value=path+"db_name_to_backup"+d;
FrmDM->ADOStoredProc1->ExecProc();
Application->MessageBox("备份完成","提示",MB_OK+MB_ICONINFORMATION);
this->Close();
}
catch(...){
Application->MessageBox("备份出错,请重新再来","警告",MB_OK+MB_ICONWARNING);
return;
}
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
- Builder中,sqlserver在客户端调用存储过程向服务器端备份
- 中,sqlserver在客户端调用存储过程向服务器端备份
- 在SQLServer的存储过程中调用Com组件
- 在SQLServer中调用外部扩展存储过程
- sqlserver 链接服务器在存储过程中调用的设置
- sqlserver 存储过程备份
- C#SQLServer中存储过程的调用
- sqlserver存储过程调用
- SQLServer 中存储过程返回的三种方式( 包括存储过程的创建, 在存储过程中调用, 在VS中调用的方法)
- 如何在sqlserver中写存储过程
- C++Builder 调用存储过程
- C++builder调用存储过程
- sqlserver在调用存储过程中遇到convert转换失败问题的解决方法
- sqlserver与存储过程在java中的调用
- sqlserver调用外部存储过程
- java调用SQLSERVER存储过程
- Hibernate 调用sqlserver存储过程
- Hibernate调用SQLserver存储过程
- const修饰指针和引用释疑
- 徘徊
- SCOUNIX下磁带机的安装与备份
- 快速初始化内存(1)
- 用于Office2007的2003样式菜单
- Builder中,sqlserver在客户端调用存储过程向服务器端备份
- 快速初始化内存(2)
- 一次"惊险"的数据恢复经历
- OfficeClassicMneu(For Excel2007)
- J2EE应用程序部署的一些建议(2)
- 更改工作表的CodeName
- 国内企业实施ERP的思考
- [转]后现代婆婆致未来儿媳的信
- 实例简析XPath串函数和XSLT