Wednesday, June 12, 2024
HomeProductsSQL Server ToolsImport/Export Connections Using dbForge Studio for SQL Server

Import/Export Connections Using dbForge Studio for SQL Server

If you need to work with multiple connections, you can easily import them into dbForge products with just a little preparation. Let us show you how it’s done with dbForge Studio for SQL Server, one of our flagship solutions that help you perform dozens of diverse database development and management tasks from a single IDE.

Download dbForge Studio for SQL Server

The import process consists of nine steps:

Without further ado, let’s get started!

1. Create a file with connection properties by template

Your preliminary task is to create a file with the .settings extension that contains conventional XML with all the connections that you want to import. You can do it using any text editor such as Notepad++. The results must look similar to those shown in the screenshot below, where each block represents a connection. There can be as many connections as you like.

The file with connections
Variable Description
Connections States the connection settings of the server.
Database Specify the GUID (Globally Unique Identifier) of the database. It’s a unique binary number in the network.
ConnectionString Define the connection string with the parameters required to connect to the server.
Name Enter the connection name that you use when you work with databases in SQL.

2. Use the Import and Export Settings Wizard to import the connections

Open dbForge Studio for SQL Server. Go to the Tools menu > Import and Export Settings.

The Import and Export Settings menu

The Import and Export Settings Wizard opens.

3. Select the “Import selected environment settings” option

Select Import selected environment settings and click Next.

Import selected settings

4. Save your current settings for sure

If you have any previously configured settings, on the Save Current Settings page, select either to overwrite your current settings or to save them to a file. Then click Next.

Save current settings

5. Choose settings to import

On the Choose settings to import page, click Browse.

Browse for the file with connections

6. Select the file that contains the connection properties

Select the XML file with connections that you have prepared during Step 1. Then click Open.

Select the file with connections

7. Check everything and load the file

Provided that the file has been assembled properly, the wizard will show the following. Click Execute.


8. Finish the import

When the import is complete, click Finish.

Finish the import

9. Verify the connections in the Database Explorer

Now your new connections will be displayed in the Database Explorer of dbForge Studio, and you are all set to work with them.

New connections in Database Explorer

Similarly, you can export your connection settings via the same Tools > Import and Export Settings menu. Only this time you need to select Export selected environment settings, specify the settings that you want to export, provide a path and a name for the output file that they will be saved to, and, finally, click Execute. Fast and easy.

The exported file is a good way to share SQL Server connections with your teammates—for instance, if your team needs the same connection settings for test servers. In this case, you can easily place this file in a shared folder or commit it to a Git repo.

Let us reiterate that this method works just as well for other dbForge products.

As for dbForge Studio for SQL Server—if you aren’t acquainted with it yet—it is a high-end alternative to SSMS, a comprehensive development environment that delivers a multitude of capabilities:

  • Advanced SQL code completion, refactoring, and formatting
  • Comparison and synchronization of database schemas and objects
  • Table data comparison and deployment of changes
  • Visual database design
  • Visual query building
  • Integrated version control
  • T-SQL debugging
  • Generation of realistic test data
  • Generation of comprehensive database documentation
  • Data export and import with up to 14 supported formats
  • Database administration and security management
  • …and much more!

You can check all of them firsthand during a free 30-day trial. Just download the Studio and give it a go!

Download dbForge Studio for SQL Server for a free trial