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 |
|
myownla
Starting Member
2 Posts |
 Posted - 2005-04-26 : 18:00:43
|
| I want to export one of the whole(including user etc.) database and import into different server which already have a diffent version of the same database. I tried to export using DTS export into Excel file, it exported only tables and data not the users etc., and also got lots of object exists error while importing ... Is there a way to export the whole database and overwrite that into differwnt server?? |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-04-26 : 23:52:51
|
| Why dont you try DTS From Server To Server?.There you can export/import all objects.Karunakaran___________It's better to be loved and lost, than ever to be loved... |
 |
|
|
myownla
Starting Member
2 Posts |
Posted - 2005-04-28 : 13:28:57
|
| There is no network connection between the servers. |
|
|
|
mpetanovitch
Yak Posting Veteran
52 Posts |
Posted - 2005-04-28 : 13:36:02
|
| Script all objects and specify the objection to drop/create.Right click on a table in EM, all tasks, generate sql scripts.From there its easy.Mike Petanovitch |
|
|
|
|
|
|
Using DTS export/import