SQLServer2000 Database Structure Populat - 未名空间MITBBS历史存档

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

Redian新闻

>未名空间

>Database - 数据库

SQLServer2000 Database Structure Populat

SQLServer2000 Database Structure Populat# Database - 数据库

g*o2003-12-09 08:12

1 楼

Could anybody give me an idea about how to populate database structure from
SQL server 2000 easily? I have several databses and lots of data inside those
database. Thanks.

D*N2003-12-09 08:12

2 楼

You can make a copy of the database, trucate all the tables, then
make a backup of that blank database to restore to other locations...

【在 g***o 的大作中提到】

: Could anybody give me an idea about how to populate database structure from
: SQL server 2000 easily? I have several databses and lots of data inside those
: database. Thanks.

g*o2003-12-09 08:12

3 楼

I have more than 50 tables for each DB and more than 10 DBs, Is that too
tedious?

from
those

【在 D****N 的大作中提到】

: You can make a copy of the database, trucate all the tables, then
: make a backup of that blank database to restore to other locations...

D*N2003-12-09 08:12

4 楼

there's a sp command to list all the tables in a database,
you can use a cursor to loop through all the tables... see
this example here..
http://www.databasejournal.com/img/TruncTables.sql

【在 g***o 的大作中提到】

: I have more than 50 tables for each DB and more than 10 DBs, Is that too
: tedious?
:
: from
: those