moving and importing register servers from pc to pc

[isonlyme]

Hi all,

I have 100 server group by location:

State1
servername1
servername2

State2
servername1

I need to move all those groups and server registration to another pc. I exported the list but how do I imported on the other pc?


I found 1 solution involving exporting the REGISTERED SERVER X from the registry but when i imported, Enterprise Manager only shows the groups not the server below:

State1
no tiems
State2
no items

Even thou the registry key show all the grops and their corresponding server names.

Any suggestions?

Thanks in advanced

 

[Broad21]

Right click on the server Group then select import, navigate down to the export file then click ok. Make sure you have all password and users name exported from the original server group.

 

[isonlyme]

sorry but i dont see the import option in SQL 2000 enterprise manager, after following your suggestion...

 

[mrdenny]

That solution only works in SQL 2005. Exporting and Importing the SQL 2000 registered server list almost never works well.

You can install the SQL 2005 tools on the old machine, and have it import the list of servers from the SQL 2000 tools. Then export from the SQL 2005 tools and import to the SQL 2005 tools on the new PC. You will have to use the SLQ 2005 tools from then on, on the new machine.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[isonlyme]

ok thank you very much for the help...