Copy Table w/ Constraints and Indexes

[stevensteven]

Hi,

I was wondering if there is an easy way for me to copy a bunch of tables, including indexes, and constraints, so i can load then on another database.

Thanks for any help,


Steven

 

[snag56]

Please define "another database".
Another SQL Server, or do you mean another DBMS,
such as Oracle, MySQL, etc.

If you mean another SQL Server (SQL2000),
you can use DTS to do the job.

If some other flavor of db, then it gets more involved.