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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-20 : 08:14:36
|
| Mike writes "If possible I want to combine two separate SQL 7.0 Servers into a singel SQL 7.0 Server. The particulars are:1) NT 4.0 Server = FrxSrvr Sql Server = FrxSrvr (8 DBs)2) NT 4.0 Server = SSSrvr Sql Server = SSSrvr (60 DBs)I want to combine the SSSrvr databases and the FrxSrvr databases together on the FrxSrvr SQL Server.I know I can detach, copy, and attach databases. My concern is whether or not I can combine the MASTER database to capture all users, etc. from SSSrvr. Am I dreaming?Thanks." |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-11-20 : 11:37:58
|
| You can transfer the users and just about any object using DTS. |
 |
|
|
thomasom
Starting Member
7 Posts |
Posted - 2002-11-27 : 11:16:24
|
| Thank you. |
|
|
|
|
|
|
SQL 7.0 - Combine two SQL 7.0 Servers