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 |
|
Lainkes
Starting Member
3 Posts |
 Posted - 2007-10-25 : 04:15:17
|
| Hey,I have a database with several tables.Some of these tables have keys.When I do an export of the DB on the same server, everything is copied to the new DB, but all my keys are gone.Any idea how I can resolve this?Thanks Lainkes |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2007-10-25 : 05:58:19
|
| you can take the backup of database and restore it with new name on the same server or can script all the tables and run that script on new DB and finally export data |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-25 : 22:23:36
|
| If you copy objects in ssis, you can include keys to copy over. |
|
|
|
|
|
|
Export database to same server