When export/import table, the primary keys are not kept.

Question

When export/import table, the primary keys are not kept.

Richard Cranston

Hall of Fame

Points: 3680
More actions
July 21, 2004 at 10:19 am

#59842

When export/import table from one database to another, the primary keys are not kept. Any suggestions? Thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

I assume you're using the wizard. Are you dropping and creating the destination table each time? Can you post the table schema indicating the primary key?

Greg

Richard Cranston Hall of Fame Points: 3680 More actions · Answer 2

Yes, I am using the wizard. Initially, the target table does not exits.

Once the target table is created, I delete the records and add the keys.

Then I use the wizard again to append records to the target table.

I do not know what you mean "post the table schema"?

JM-92548 Ten Centuries Points: 1108 More actions · Answer 3

Best way create the table before hand. Create all your keys and use the wizard to copy.

If the tables in both databases are the same. Script the one table then run the sql in the query analyzer for the other databse

Greg Charles SSC-Forever Points: 45403 More actions · Answer 4

So, are you saying that when you import the data, the primary key contraint goes away or the values for the columns that make up the primary key aren't imported?

By schema, I mean the layout of the table, including column data types and which columns make up the primary key.

Greg

viniciuscv Grasshopper Points: 16 More actions · Answer 5

Sorry to introduce my opinion.

If you want you can use in the Dialog Box with name "Specify Table Copy or Query" - Copy objects and data between SQL Server Database. There you can create a tables with a primary key, procedures, triggers and so on.

Vinicius B Cobra Vivas

Richard Cranston Hall of Fame Points: 3680 More actions · Answer 6

When running the wizard to create the target table, the primary key contraint goes away.

In the prompt "Specify Table Copy or Query", three options are available:

1. Copy Tables and views from source database

2. Use a query to specify the data to transfer

3. Copy objects and data between databases

Currently, I use option 1, which the primary key contraint is dropped.

So I should be using option 3 instead?

firstrate Old Hand Points: 379 More actions · Answer 7

Yes if you use option 3 the keys will be transfered with the data- just make sure the option is checked.