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 |
|
creane
Starting Member
11 Posts |
 Posted - 2003-09-10 : 12:26:13
|
| Hi, I hope to copy a database from one domain to another (different regions). The databases are quite large so I was hoping to use dts instead of backup/restore over teh network. Ive tried using dts import (copy objects, tables and views) which causes an error whereby a message indicating that the dts failed due to a odbc error login (administrator) does not exist). (the database is actually copied but the constraints etc on teh tables are not copied) Ive tried using the dts with the sa accounts for both machines but this doesnt work either..Any help greatly appreciated.. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-10 : 12:37:28
|
| Using DTS is going to slow you down tremendously, especially since the databases are quite large. BACKUP/RESTORE or attach/detach is going to be the method for you. DTS will not copy ove rthe constraints as you mentioned, so there will be additional work to do after the base table and data is copied over. BACKUP/RESTORE or attach/detach will copy everything over. So why don't you want to use the BACKUP/RESTORE method? It will be much faster and easier for you.Tara |
 |
|
|
creane
Starting Member
11 Posts |
Posted - 2003-09-10 : 13:04:02
|
| Thanks for the reply , I assumed that the import wizard (selected copy and objects and data ) would do this i.e. create constraints referential integrity etc as it indicates this at the top of the dialog that this wizard will do that..? -if you select the create objects tables, views etc radio button?thnks againEric |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-10 : 13:15:52
|
| I haven't ever used the import wizard, so it just might create everything that you need. But it is still going to a lot slower than the BACKUP/RESTORE method. So why don't you want to use the BACKUP/RESTORE method? It will be much faster and easier for you.Tara |
|
|
|
|
|
|
dts copy objects & error