Author |
Topic |
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2004-10-06 : 12:30:39
|
I have recently received a new computer here at work. This is a wonderful thing except that all the databases I had mapped in Enterprise Manager are of course gone. Is there a place on my old computer that I can go to and copy those map settings into my new box?Thanks!Adrian |
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-10-06 : 13:06:32
|
Yo! Pool Dude.7 more posts![Danger Wil Robinson...there be WAGs]And this is just a guess....make sure to backup the original before you try...Try and copy thisSQL Server Enterprise Manager.MSCTo your new box....[/Danger Wil Robinson...there be WAGs]Brett8-) |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2004-10-06 : 13:27:08
|
Thanks Brett, I will give it a try and report back!Adrian |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-06 : 14:26:17
|
I've never tried the MSC way so I don't know if that'll work. What I know works is exporting the registry entries and importing that into the new box. How many servers are we talking about? BTW, I don't remember the registry entry as it has been over 2 years since I've done that hack.Tara |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2004-10-06 : 16:09:46
|
For myself, I have 6 registrations.My supervisor is linked up to about 9 or 10. Can you give some further advice on the registry hack Tara?Adrian |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-06 : 16:13:50
|
Found it:HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers XThis is for SQL Server 2000 only. The 70 and 65 servers are located elsewhere.Tara |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2004-10-06 : 16:54:27
|
The registry hack worked!!!!Thank you Tara! (and brett, sort of )Adrian |
|
|
AndyThissen
Starting Member
7 Posts |
Posted - 2005-04-04 : 13:59:58
|
Any other ideas on what I need to export to move my EM settings to a new PC? I tried both the reg and the file copy. The new Enterprise Manager only sees the Groups I had created on the old client. Your help is appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-04-04 : 14:06:58
|
Did you copy all of the string values underneath each eky in Registered Servers X? To do this, highlight Registered Servers X, go to File..Export. Save it to a file. Copy that file name over to your new box. Double click on it. Is that what you did? If so, I've never seen it not work for 2000 servers. Do you have a mix of 2000 and other older versions of SQL Server?Tara |
|
|
|