DTS between Sql server 2000 and sql server 7

[jan11]

I am using a DTS import option on a sql server 2000. I am trying to copy the tables and data from a sql server 7 database. The DTS import runs fine and copies over all the tables and data. The only problem is it does not copy over the default value settings of a column in a table. For example a column "OrganizationID" in the table "Organization" (on the sql server 7 database) has a default value of '100' set to during design of the table. and is a 'not null' column. This default value is not copied over in the organizationID column of the table organiztion (on server 2000) after the DTS import?
Is there a solution to copy these default field values over too?

 

[mrdenny]

DTS doesn't copy table definitations like default values and indexes etc. Those need to be moved over seperatly.

You need to script the table(s) in Enterprise Manager and use that to recreate the table(s) on the second server.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)