DB: lab PC<-> home PC - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

DB: lab PC<-> home PC

DB: lab PC<-> home PC# Database - 数据库

d*t2003-05-03 07:05

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*s2003-05-03 07:05

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*t2003-05-03 07:05

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