How to transfer the registered SQL Servers

  • U J

    SSCrazy

    Points: 2420

    Hi Guys !

    I have around 50 servers registered on my client machine,now i want to transfer these registred servers to another client machine,is there any method to transfer these logins without much efforts(may be using some scripts to transfer)

    or do i need to manually register each and every server to another client machine..?

    thnks 4 any help !

  • Ninja's_RGR'us

    SSC Guru

    Points: 294069

    Not sure how much this helps... but you can get a list of registered servers on the local pc here :

     

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

     

    I'm not srue how I'd go into turning this into a script tho...

  • U J

    SSCrazy

    Points: 2420

    Thnks !

    I think by exporting this registry value and importing this value to another client machine may help !

    thnks a lot

  • Ninja's_RGR'us

    SSC Guru

    Points: 294069

    NP, but I will suggest that you backup the client's registry before importing :-).

     

    Let us know how this works for ya.

  • Carl Federl

    One Orange Chip

    Points: 25384

    Although exporting/importing registry did work at one time, this method no longer works. The good news is that Gustavo Merle has written a VBS to perform this function.

    http://www.sqlservercentral.com/forums/printtopic.aspx?forumid=24&messageid=270935

    SQL = Scarcely Qualifies as a Language

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

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