d****t
发帖数: 362 | 1 Hi, guys,
I want to setup an exactly same developement environment at home as in my lab.
Everything is fine, except that I don't know how to clone everything in the
database. (MS SQL Server 2000). Someone said using the Enterprise Manager and
script loader to transfer everything in the database. But I am not 100% sure.
Any suggestion and advice is warmly welcomed! | e*********s
发帖数: 200 | 2
lab.
and
sure.
From your source SQL Server, Enterprise manager,
pull down menu:
Tools | Data Transformation Services | Export Data
follow the wizard to export your database(s) to your target server :)
Or
you can detach your databases from your source server, copy them to your
destination server, then attach them :)
see online books for sp_detach_db and sp_attach_db for more details :)
Good luck ^o^
PS:
If you want to synchronize between two SQL server databases, you'd better
define a publisher/
【在 d****t 的大作中提到】
: Hi, guys,
: I want to setup an exactly same developement environment at home as in my lab.
: Everything is fine, except that I don't know how to clone everything in the
: database. (MS SQL Server 2000). Someone said using the Enterprise Manager and
: script loader to transfer everything in the database. But I am not 100% sure.
: Any suggestion and advice is warmly welcomed!
| d****t
发帖数: 362 | 3 Nu!
Thanks.
the
【在 e*********s 的大作中提到】
:
: lab.
: and
: sure.
: From your source SQL Server, Enterprise manager,
: pull down menu:
: Tools | Data Transformation Services | Export Data
: follow the wizard to export your database(s) to your target server :)
: Or
: you can detach your databases from your source server, copy them to your
| d******e
发帖数: 2265 | 4 rsync
【在 d****t 的大作中提到】
: Hi, guys,
: I want to setup an exactly same developement environment at home as in my lab.
: Everything is fine, except that I don't know how to clone everything in the
: database. (MS SQL Server 2000). Someone said using the Enterprise Manager and
: script loader to transfer everything in the database. But I am not 100% sure.
: Any suggestion and advice is warmly welcomed!
|
|
