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 |
|
rajk
Starting Member
20 Posts |
 Posted - 2004-02-06 : 04:32:45
|
| I am trying to create a new database as a copy of an existing database. For this, I am doing an 'Export'. While exporting, I am using the option 'Copy objects and data between SQL Server databases'. It does not copy the constraints (like primary key constraints, identity constraints etc.).I have the 'Copy all objects' checked. What should I do to get EVERY THING on to the new database from the current databse?ThanksRaj |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2004-02-06 : 04:59:25
|
| Unmark "Use default options" (on the same page as "Copy all objects")and check the selected export options.BR |
 |
|
|
The Enigma
Posting Yak Master
179 Posts |
Posted - 2004-02-06 : 05:03:37
|
| Why not take a backup and restore it ??? |
|
|
|
|
|
|
Copy one database into other