Microsoft SQL Server forum - DTS Table Import Issue

Author

DTS Table Import Issue

Scott

2005-10-28, 8:23 pm

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.

John Bell

2005-10-29, 11:23 am

Hi

Using the Copy SQL Server objects task will normally copy defaults. You can
see what options you are using by clicking the options button on the copy
tab.

This sounds like you are using the export/import wizard and the copy tables
option instead of the copy database objects option.

John

"Scott" <scott.llewellyn@gmail.com> wrote in message
news:1130530964.830896.206710@o13g2000cwo.googlegroups.com...
>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.
>

Scott

2005-10-31, 9:23 am

Yes, I was using copy tables and views within DTS. I have since tested
with copy objects and data and it does copy the table properties over.

Thanks so much!

Scott

Sponsored Links