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 |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2005-12-14 : 13:28:16
|
| Anyone know how I can copy all of my Server registrations over to anthoer client?I just go a laptop from the office and I want to know if it's possible to copy a file to it so I can see everything I have registered already.Is this possible?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-12-14 : 13:56:02
|
| it is possible, there is a thread here with that information. I'll dig around. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-14 : 14:15:03
|
| Migrate this maybe?HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\Client\PrefServersKristen |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-14 : 14:35:20
|
| I dont know if i fully understand your question.copy or connect to your company server ?if its the latter, i use the client network utility and then register the server in EM. Is this what you want ? or am i misunderstanding ?Afrika |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-12-14 : 14:47:11
|
| the EM server registrations are encrypted in the registry. If you backup the registry key that contains them, and move it to another machine it won't work. You will get the groups, but none of the registered servers will show up.there is a solution though. I found some scripts online a while back that will make this job really easy. I could not find the original post here at sqlteam for some reason though, but I know it is here somewhere...Anyway, here is the original link from google groups with 2 solutions given: http://groups.google.com/group/microsoft.public.sqlserver.tools/browse_frm/thread/555a22597f39a440/57b165af41045530Here is another page that has the javascript/xml solution http://glossopian.co.uk/pmwiki.php?n=Main.BackupEnterpriseManagerSettingsI have found that exporting EM hierarchies containing nested groups does not work with these solutions. You can only export up to one level deep. Maybe someone can fix that, but for now it works fine for our purposes.-ec |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-14 : 14:58:28
|
| One thing i noticed about you eyechart is you are always detailed and direct in your responses. Quite impressive :-)Whats wrong in doing a fresh registration of servers on the new machine ?Afrika |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-12-14 : 15:03:39
|
quote:
Originally posted by afrika
One thing i noticed about you eyechart is you are always detailed and direct in your responses. Quite impressive :-)Whats wrong in doing a fresh registration of servers on the new machine ?Afrika
Thx for the compliment  The reason we use a script like this is if you have dozens and dozens of registered servers (like we do) organized in some fashion it can be very time consuming to rebuild them.At work we have implemented a common management server (in vmware) that all the SQL DBAs use. We regularly schedule backups of the registered servers just in case using the javascript method i posted about. This also makes it easy to migrate the server registrations to your laptop or a new system being setup. Having the same registrations on two systems (laptop and remote desktop to the server) gives us some really good flexibility for managing our stuff.-ec |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-14 : 15:12:05
|
| Ok Sirgracia !!! Keep up the good work.but i wonder why i am not getting any automated response to my subscriptions |
|
|
|
|
|
|
Copy Registered Servers