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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-27 : 08:02:17
|
| rbrook writes "Is there a setting somewhere to avoid this? When I export a SQL table to another server, the default values are dropped, the keys don't show up and numeric datatypes become decimal. Thanks in advance for any tips." |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-04-27 : 09:02:56
|
| There's a few ways you could be exporting so I'm not sure about your specific scenario. I'll share my experience with you. I have an inherent distrust of DTS for anything more than simply moving data. I always create my structure on the on the destination server first, then just fill in the data with DTS or a job if needed.Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
DTS Export drops default values