Here you will find the steps necessary to export and then import SQL 2005 registered server information from one database server to another.
1. From the “Registered Servers” window (CTRL+ALT+G) right mouse click on a registered server Database Engine name and from the context menu select “Export”.
2. From the Export Registered Servers task screen expand the “Database Engine” and select the registered server name you want to export. Then from “Export options” enter a location and file name to save the export file to in the “Export file” text box such as \\ServerName\ShareName\FileName and then select “OK” ” to create the XML based file.
3. At the Export Registered Servers dialog box select “OK” to close “The export was successful” Message box.
To Import the information to another database server follow the steps here:
1. From the “Registered Servers” window right mouse click on a registered server Database Engine name and from the context menu select “Import”.
2. From the Import Registered Servers task screen select the ellipsis to browse for the file that you exported in step 2 above and then select “Open”.
3. Next select “OK” and follow the prompts to complete the process.
Example MachineName.RegSrvr File
<?xml version="1.0" encoding="utf-8"?>
<Export serverType="8c91a03d-f9b4-46c0-a305-b5dcc79ff907">
<ServerType id="8c91a03d-f9b4-46c0-a305-b5dcc79ff907" name="Database Engine">
<Server name="MachineName" description="Local instance - 'MachineName'">
<ConnectionInformation>
<ServerType>8c91a03d-f9b4-46c0-a305-b5dcc79ff907</ServerType>
<ServerName>MachineName</ServerName>
<AuthenticationType>0</AuthenticationType>
<UserName />
<Password />
<AdvancedOptions />
</ConnectionInformation>
</Server>
<Server name="MachineName" description="">
<AdvancedOptions>
<CONNECTION_TIMEOUT>15</CONNECTION_TIMEOUT>
<EXEC_TIMEOUT>0</EXEC_TIMEOUT>
<PACKET_SIZE>4096</PACKET_SIZE>
<ENCRYPT_CONNECTION>False</ENCRYPT_CONNECTION>
</AdvancedOptions>
<Group name="Local" description="" />
</ServerType>
</Export>
No Comments