Not an FAQ - Regarding importing/exporting tables 1

[Deadline]

Hi,
I am using SQL Server 7.0 Desktop edition.

I have two databases - Production and Test

I did all my work over the TEST Database; when we decided to make the project live, I tried to export all the tables from the TEST to PRODUCTION. I did work well fine.. BUT the columns that I have designated as Identity columns in the TEST database - they are never got exported as an Identity columns, rather they go as ordinary columns only. I had to go and fix it each time.. I mean, is this a result of natural behaviour of the Export Wizard or is this something abnormal ?

F1 please. Thank you...
RR

 

[tlbroadbent]

I assume you used the DTS wizard to do the export. Did you select "Copy table(s) and view(s) from source database" or "Copy objects and data betweeen SQL Server databases"? You must choose the latter to properly copy the schema.

Make sure "Include all dependent objects" is checked on the "Select objects to copy" screen. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.

 

[Deadline]

Hi Terry..
Thank you very much..
I used the DTS wizard for the export. And I selected the first option that is - "Copy Tables and views from the
Source Database" out of the 3 options provided.

And I think I didn't verify whether that "Include all dependent objects" was checked or not..

And do we have a posting or article in Tek-Tips or in the Web that tells us how do importing and exporting without a wizard ? Because wizard is no fun...
Thank you...
RR