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 - 2003-12-31 : 08:15:38
|
| Alex writes "I have several SQL server groups with about 70 registered SQL servers in my old desktop SQL Server Enterprise manager.Question: Is there an easy way to migrate all these registrations to another SQL Enterprise manager sitting on a new box without doing it manually (one by one).Thank you in advance." |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-12-31 : 15:00:03
|
| You can use SQLDMO to do this. You need a VBScript to export your registered servers to a text file and another one to run on your new PC to add them. I've never quite got round to writing it but I'm sure someone out there has , hopefully it gives you the idea. |
 |
|
|
|
|
|
SQL Server Enterprise Manager configuration