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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2004-06-01 : 03:19:38
|
| When I export my database using dts I find that I lose all identity collumns (or rather they are not set to identity) and I lose key information. Is there any setting to stop this? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-06-01 : 06:17:20
|
| No, create your tables on the new database before copying the data into them, if you script the tables out, it will keep the identity columns... |
 |
|
|
|
|
|
dts - copying table loses identity collumns