网站上有一数据库,我怎么把数据传到本地机器? rt,谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用ado,你这个怎么传是什么意思??读取数据吗?还是导出备份? 谢谢shadowfish(小鱼) ,谢谢大家!是这样的:----------------------------------------------------------一家公司,在公司接待客户,在本地录入资料,同时公司在IDC租了空间,开了网站,允许客户网上输入,现在想把网站上的数据库里的数据传到本地机器数据库,实现数据库的统一。 利用SQL的分布式管理可以做到这一点,但是我没有用过。我过去是采用这样的方法做的,直接传备份文件,然后用SQL SERVER2000的Transact Sql语句来完成的,这样只能在一定时间内执行一次,没有了实时性,比如每一个小时执行一次backup和restore来完成,但是速度成问题。BACKUP DATABASE { database_name | @database_name_var } TO < backup_device > [ ,...n ] [ WITH [ BLOCKSIZE = { blocksize | @blocksize_variable } ] [ [ , ] DESCRIPTION = { 'text' | @text_variable } ] [ [ , ] DIFFERENTIAL ] [ [ , ] EXPIREDATE = { date | @date_var } | RETAINDAYS = { days | @days_var } ] [ [ , ] PASSWORD = { password | @password_variable } ] [ [ , ] FORMAT | NOFORMAT ] [ [ , ] { INIT | NOINIT } ] [ [ , ] MEDIADESCRIPTION = { 'text' | @text_variable } ] [ [ , ] MEDIANAME = { media_name | @media_name_variable } ] [ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ] [ [ , ] NAME = { backup_set_name | @backup_set_name_var } ] [ [ , ] { NOSKIP | SKIP } ] [ [ , ] { NOREWIND | REWIND } ] [ [ , ] { NOUNLOAD | UNLOAD } ] [ [ , ] RESTART ] [ [ , ] STATS [ = percentage ] ] ]RESTORE DATABASE { database_name | @database_name_var } [ FROM < backup_device > [ ,...n ] ] [ WITH [ RESTRICTED_USER ] [ [ , ] FILE = { file_number | @file_number } ] [ [ , ] PASSWORD = { password | @password_variable } ] [ [ , ] MEDIANAME = { media_name | @media_name_variable } ] [ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ] [ [ , ] MOVE 'logical_file_name' TO 'operating_system_file_name' ] [ ,...n ] [ [ , ] KEEP_REPLICATION ] [ [ , ] { NORECOVERY | RECOVERY | STANDBY = undo_file_name } ] [ [ , ] { NOREWIND | REWIND } ] [ [ , ] { NOUNLOAD | UNLOAD } ] [ [ , ] REPLACE ] [ [ , ] RESTART ] [ [ , ] STATS [ = percentage ] ] ]你可以参看transact sql的帮助,最好能用分布式事务处理来完成 DTS 导入导出,或者自己写程序获取新的数据,导入到其他服务器上。 本地有sqlserver吗????????????????? to pengdali(大力) :本地有sqlserver,谢谢! to shadowfish(小鱼) :怎么从从远程读取数据啊,能说详细一点么?谢谢!!! 遇到一奇怪问题 1000分求论文:UP给分。人事管事系统论文。或者学校档案管理系统论文。或者学校学籍管理系统论文。 关于Tstringlist的用法 急手问题,是关于窗体的。 !!!!!!!!!!文件传送问题!!!!!!!!!!!! 怎样安装自己的数据库? 请教怎样在memo中显示网页? (100分)谁有加密算法?不需要太复杂,但是一定要PASCAL描述的,急用,没工夫细细琢磨,拜托给为大虾。 怎样输入日文?各位帮帮我! 如何实现Form标题栏上的最小化功能,急! 求救!关于sql一个非常简单的问题。 QuickRep在哪里?
----------------------------------------------------------
一家公司,在公司接待客户,在本地录入资料,同时公司在IDC租了空
间,开了网站,允许客户网上输入,现在想把网站上的数据库里的数据
传到本地机器数据库,实现数据库的统一。
BACKUP DATABASE { database_name | @database_name_var }
TO < backup_device > [ ,...n ]
[ WITH
[ BLOCKSIZE = { blocksize | @blocksize_variable } ]
[ [ , ] DESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] DIFFERENTIAL ]
[ [ , ] EXPIREDATE = { date | @date_var }
| RETAINDAYS = { days | @days_var } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] FORMAT | NOFORMAT ]
[ [ , ] { INIT | NOINIT } ]
[ [ , ] MEDIADESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]
[ [ , ] NAME = { backup_set_name | @backup_set_name_var } ]
[ [ , ] { NOSKIP | SKIP } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
]RESTORE DATABASE { database_name | @database_name_var }
[ FROM < backup_device > [ ,...n ] ]
[ WITH
[ RESTRICTED_USER ]
[ [ , ] FILE = { file_number | @file_number } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]
[ [ , ] MOVE 'logical_file_name' TO 'operating_system_file_name' ]
[ ,...n ]
[ [ , ] KEEP_REPLICATION ]
[ [ , ] { NORECOVERY | RECOVERY | STANDBY = undo_file_name } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] REPLACE ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
]你可以参看transact sql的帮助,最好能用分布式事务处理来完成