DTS Import Table Issue

DTS Import Table Issue

Post by Scot » Sun, 30 Oct 2005 05:27:37


I am using DTS to import tables into my new database from another
database, both of which reside on the same server. All the tables,
fields and data copy over fine; however when I go into design view of
the copied tables, the default values for all the fields are lost. It
seems to copy the structure, but not the field properties.

I could manually set the values, but this could prove to be very time
consuming. Thought I may have overlooked a setting or simply missed a
step.

Is it possible to have these properties copied over?

Any help/input would be appreciated.
 
 
 

DTS Import Table Issue

Post by Allan Mitc » Sun, 30 Oct 2005 18:30:49

Hello scott,

I have just tried this using the Copy SQL Server Objects task and it works
on this structure

CREATE DATABASE A
GO
USE A
CREATE TABLE A(col1 int default 0)
GO
CREATE DATABASE B
GO

I then move A(A) to B(A)


What options do you have set on the final tab of the task?

Allan

 
 
 

DTS Import Table Issue

Post by Scot » Tue, 01 Nov 2005 23:24:54

Another user has pointed out what I was doing wrong; I was using copy
tables and views within DTS Import/Export instead of copy objects and
data.

Thanks for the reply,
Scott