Moving SQL Server Registrations to new PC

Question

Moving SQL Server Registrations to new PC

Kate Harkness

SSC Rookie

Points: 25
More actions
January 5, 2007 at 10:00 am

#193830

I just received a new laptop and have about 30 registered SQL Servers. Is there a way to move them to the new pc, without having to manually re-register? Thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Russel Loski SSCertifiable Points: 7059 More actions · Answer 1

Try this:

http://groups.google.com/group/microsoft.public.sqlserver.clients/browse_thread/thread/53aa505a6aaaeaaa/4fe1fd11b0a51a62%234fe1fd11b0a51a62

Russel Loski, MCSE Business Intelligence, Data Platform

Kate Harkness SSC Rookie Points: 25 More actions · Answer 2

Thanks for the suggestion. That actually exports the SQL Server Groups, but not the individual servers under each group. Any other ideas?

Tom Goltl SSCertifiable Points: 5815 More actions · Answer 3

I haven't tested this, but a quick look through the registry got me to this key:

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group]

You can try exporting from your old machine and importing to new machine and see if it works.

Tom

Kate Harkness SSC Rookie Points: 25 More actions · Answer 4

That is actually what the first response indicated also; however, it only exports the Registered Groups and not the server within the group. Thanks for the idea though!

Tom Goltl SSCertifiable Points: 5815 More actions · Answer 5

I just did it and it worked fine for me. You have to export each group individually under the Registered Servers X key. Try it I think you'll find it works. I created a new group, added a server, exported the registry file, deleted the registration and the group, ran the registry file and fired enterprise manager up again and the group and registered server re-appeared.

Tom