SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Import/Export SQL Server 2000 Enterprise Manager Registered Servers

By Chad Miller,

Powershell script to import or export SQL Server 2000 Enterprise Manager group and server registrations.

Note: SQL Server 2000 Enterprise Manager should be installed and then launched to initialize the registry keys. Close Enterprise Manager prior to running script.

To use you'll need to source the Powershell Script.

Save the file as sqlem.ps1

Launch Powershell cd to the file location

. ./sqlem.ps1

This will source the Powershell script which simply defines the functions but does not execute the script. Example usage to export and import server registrations to c:\serves.txt file:

Export-RegisteredServers c:\servers.txt


Import-RegisteredServers c:\servers.txt

Total article views: 2492 | Views in the last 30 days: 2
Related Articles

Execute SQL Script against Multiple Servers by PowerShell

Execute SQL Script against Multiple Servers by PowerShell


Export SQL Server Error Messages from Event Viewer As HTML

i use the following powershell script to retrive all sql server error logs from event viewer and exp...


Scheduling a PowerShell Script Using SQL Server Agent

This article will give you insight to understand how you can schedule a powershell script you have w...


PowerShell – Export SQL Data to Excel with Powershell

SQL Server  Export  to Excel with Powershell is very useful for all sorts of activities – ETL an...


Exports in SQL Server

Exports in SQL Server