Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
simondeutsch
Aged Yak Warrior
547 Posts |
 Posted - 2002-10-30 : 11:06:40
|
| When using DTS to import table structures only, with no data, from one database to another on the same server, the (table) columns' default values do not seem to import. What is this due to?Sarah Berger MCSD |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-30 : 11:08:14
|
| The defaults are stored as objects in the sysobjects table. When using DTS to copy objects, you have an option to include the defaults, triggers, and other ancillary table structures. |
 |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2002-10-30 : 11:19:39
|
| I did check to include dependent objects, and as far as the other stuff is concerned, when you uncheck the Use Default Options, you can click the Advanced button. There, Transfer Triggers, Indexes, Keys, Full-Text Indexes, Logins, Permissions are checked by default, so it must've been checked when I imported. No word about column defaults there, though.Sarah Berger MCSDEdited: Another thing, these defaults are not objects. They are only default definitions.Edited by - simondeutsch on 10/30/2002 11:23:39 |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-30 : 12:02:56
|
| #!@!%@#$!% system objects!If you're only importing the structures, you can just script out the tables and run the script on the new server or database. It will include all of the system default objects too if you check the box to script defaults, triggers, etc. |
|
|
|
|
|
|
|
|
Table defaults not importing