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 |
|
Blastrix
Posting Yak Master
208 Posts |
 Posted - 2001-12-04 : 12:35:39
|
| Recently I have been trying to export and/or import data between two databases using DTS. After selecting my DBs, I choose "Copy objects and data between SQL Server databases". From there I choose to "Create destination objects", with options to drop destination and include dependent objects. I then specify which items I which to copy over. The problem is that when the data gets copied over, all of the default values for the tables will be gone. The data is intact, the structure is correct, but the defaults are all blank. Has anyone heard of this before and/or know of a fix for it? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-04 : 12:42:35
|
| It seems that they missed this one under the Options tab. I also noticed that "Generate SQL Scripts..." also uses a CREATE TABLE...ALTER TABLE syntax, and all defaults and constraints are added in the ALTER TABLE portion, instead of being included in the CREATE TABLE definition. So I'm not sure you'll even be able to script the original tables and then run them on the destination machine, although I'm pretty sure it will work. You'll have to test it. |
 |
|
|
|
|
|
DTS Losing Default Values