|
|
Posted by John Bell on 10/29/89 11:31
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.
>
Navigation:
[Reply to this message]
|