lose relationships on table copy 1

[kevinforbes]

Hi there,

I copied my tables from one database to another and found that the primary keys and relationships are all deleted in the destination database. Any idea why?

thanks,
K

 

[Transcend]

Hi there,

how did you copy your tables to the new database?

I like to script my database, including scripting all the
primary keys, relationships etc so that i don't lose them
in the process.

Transcend

 

[kevinforbes]

I just imported them using Enterprise Manager, I really don't want to have to script the copy since it is around 25 tables and relationships.

tx,
K

 

[tlbroadbent]

Did you select Copy table(s) and view(s) from source database or Copy objects and data between SQL Server databaseson the Specify Table Copy or Query screen? If you choose the first option, just tables and data will be copied. Objects not in the destination database will be scripted and created.

If you choose the 2nd option above (it is the 3rd option on the selection screen), SQL should copy indexes, primary and foreign keys. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[kevinforbes]

Thank you, I must have done the first, I will try the 2nd option.

K