How to import and export settings

The dbForge tool allows for exporting and importing environment settings or resetting the environment to the default collection of settings. This feature might help back up or restore settings in case of a system crash, corruption, or other unforeseen issues that may lead to settings loss.

To import and export settings, open Import and Export Settings Wizard from the ribbon by selecting Tools > Import and Export Settings. In the wizard, you can do the following:

Import and Export Settings Wizard

Export the selected settings to a file

1. In the Import and Export Settings Wizard, the Export selected environment settings option is selected by default. To proceed with the export, click Next.

2. On the Choose settings to export page, all the settings to export are selected by default. Clear the checkboxes next to the settings you want to exclude from the export and click Next.

Note

To view the full list of settings you can export, see Settings available for export and import.

3. On the Save Current Settings page, choose a file name and a location for the settings to be exported:

  • Under Settings file name, enter a file name that will store export settings.
  • Under Store my settings in this directory, specify a path to the file with the settings, or click Browse to select the file location.

Then, click Execute.

4. On the Export Finish page, click Finish to close the wizard.

Import the selected environment settings

1. In the Import and Export Settings Wizard, select Import selected environment settings and click Next.

2. On the Save Current Settings page, choose a file name and a location for the current settings:

  • Select Yes, save my current settings, a default option, to create a backup of the current settings before importing the new ones.
    • Enter a file name.
    • Specify a location for the file that will store the settings, or click Browse to select the file location.
  • Select No, just import settings, overwriting my current settings to import the new settings without saving the current ones.

To proceed, click Next.

3. On the Choose settings to import page, click Browse to select the settings file you want to import. In the Open window, select the file and click Open.

All the settings are selected by default. Clear the checkboxes next to the settings you want to exclude from the import and click Next.

Note

To view the full list of settings you can export, see Settings available for export and import.

4. Click Execute and see the result message.

5. On the Import Finish page, click Finish to close the wizard.

Settings available for export and import

The table describes settings you can export or import using the Import and Export Settings Wizard.

Setting Description
All Settings All settings available for export and import.
Connections A list of saved connections. They will be exported with an encrypted password.
General Settings General settings in the environment.
Toolbar Toolbar customizations including custom items, sort order, tabs, and custom names.
Window Layouts The state of all the tool and document windows in the environment, including their floating and docked positions.
Keyboard The list of shortcut keys available in the environment.
Options Settings that can be configured in the Tools > Options dialog.
Environment Environment settings that are available for import and export.
General Environment startup settings and active keyboard mapping scheme.
Categories A list of saved environment categories.
Documents All document settings available for export and import.
SQL documents Document behavior settings and SQL Log settings.
Query History SQL Query History settings.
Restore Settings for the restore open documents functionality.
Text Editor > General Text Editor settings that can be found in the Tools > Options > Text Editor dialog.
Advanced Text Editor Advanced settings.
Code Completion All code completion settings.
Formatting Formatting styles stored in the formatting profile files.
General General formatting settings.
Profiles A list of formatting profiles.
Azure Active Directory > Multi-Factor Authentication Azure Active Directory Multi-Factor Authentication settings.
Query Execution Options to customize query execution.
Data Editor Data Editor settings that can be found in the Tools > Options > Data Editor dialog.

Reset all settings

1. In the Import and Export Settings Wizard, select Reset all settings and click Next.

2. On the Save Current Settings page, do the following:

  • Select Yes, save my current settings to save the current settings before replacing them.
    • Enter the file name.
    • Specify the file location or click Browse to choose the file location.
  • Select No, just reset settings, overwriting my current settings to restore the default settings without saving the current ones.

3. Click Execute to reset the settings to default.

4. On the Reset Finish page, click Finish to close the wizard.