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 |
|
kdb163
Starting Member
1 Post |
 Posted - 2002-08-30 : 08:59:31
|
| I am attempting to copy a database from one SQL server to another SQL server. Currently, I am using the DTS import and export wizard to complete this task. All of the tables and and data are moving to the new server but for some reason, the data definintions are not going with it. For example is I have set a field as being required, when I move the database, the fields definition reverts back to its default. Is I am wondering if there is a trick to making sure the entire database along with its data definitions move along with it.Any assistance anyone can provied would be great.Thanks Keith |
|
|
victord
Yak Posting Veteran
64 Posts |
Posted - 2002-08-30 : 10:32:46
|
| Have you tried using the backup and restore method. That is backup the source database and restore the backup unto the destination database.Vic |
 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-08-30 : 14:34:45
|
| Which option are you using in the Export wizard? - Copy tables from source database - Use a query to specify the data to transfer - Transfer objects and data between SQL Server databasesJeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
Copying Databases from one server to another