Export and import registered servers list in SQL Server Management Studio

To export registered servers list in SQL Server Management Studio, in Registered Servers, right-click a server group you want to export, and then (under Tasks) click Export:

Choose the location where you want to save the export file, choose if you want to include user names and passwords in the export file:

Click OK to save the export file (SQL Server will store the information in XML format in a file with .regsrvr extension):

To import registered servers list in SQL Server Management Studio from the export file, in Registered Servers, right-click a server group to which you to import the servers list, and then (under Tasks) click Import (you cannot import registered server information into SQL Server 2012 from earlier versions of SQL Server):

Choose the import file (file with .regsrvr extension) and the server group to import to:

Click OK to import the list:

If the post helped you, please share it:
Pin It

1 comment to Export and import registered servers list in SQL Server Management Studio

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">