Contents

How to share custom formatting profiles

In SQL Complete, you can share custom formatting profiles with other SQL Complete users by storing them in a shared network folder or share them through Dropbox. Also, you can export profile settings so that other users can open them in SQL Complete.

The guide provides the following how-to topics:

• Install a Dropbox application on your computer
• Upload and share a profile to a shared folder
• Open the profile through a shared network or a Dropbox folder
• Export profile settings
• Import the profile settings

To upload and share a profile through Dropbox, you will need to have a Dropbox account and the Dropbox desktop application installed on your computer.

Install a Dropbox application on your computer

1. Go to the Dropbox website and click Download Dropbox App to download a Dropbox application.

2. Navigate to the folder where the installer has been downloaded and run it.

3. In the Set Up Dropbox dialog that opens, enter the e-mail and password to sign in to your Dropbox account and then click Sign in.

Note

If you do not have an account yet, click create an account and follow the steps.

4. In the Welcome to Dropbox window that opens, choose how to synchronize your files and then click Continue.

5. Click Advanced Settings and choose a location for your Dropbox folder. Then, click Done.

Next, you can share your formatting profile with other SQL Complete users by saving it in a shared folder such as a network shared or a Dropbox folder.

Upload and share a profile to a shared folder

1. Locate the profile you want to upload.

By default, formatting profiles are stored as an .xml file in the following directory: C:\Users\UserName\AppData\Roaming\Devart\dbForge SQL Complete\FormatProfiles. If you set a different path to the folder with the profile, do the following:

2. On the SQL Complete menu, click Options. In the dbForge SQL Complete: Options dialog that opens, click Formatting > Profiles.

3. Right-click the profile you want to locate and click Show in Folder.

4. In the window that opens, copy the profile and paste it into a shared network or a Dropbox folder.

After the file with profile settings has been uploaded to the shared folder, other SQL Complete users can open the file and use it in the SQL Complete tool.

Open the profile through a shared network or a Dropbox folder

1. On the SQL Complete menu, click Options. In the dbForge SQL Complete: Options dialog that opens, click Formatting > Profiles.

2. Click Create New.

3. In the New Profile dialog that opens, do the following:

• Enter the name of the profile
• Choose the settings for the profile
• Click the browse icon in the File Path field

4. In the Select File Path window that opens, choose the file you want to share - either from a shared network or a Dropbox folder. Then, click Save.

5. Click OK.

The file will be displayed in the Your Profiles section. To save the changes, click OK.

As mentioned, you can export profile settings so that other users can import them in SQL Complete.

Export profile settings

1. On the SQL Complete menu, click Import and Export Settings.

2. In the Import and Export Settings Wizard that opens, select Export selected environment settings and click Next.

3. In the Choose setting to export window, all the checkboxes are selected by default. You can clear the checkboxes by selecting All settings. Then, navigate to All Settings > Options > Text Editor > Formatting and select Profiles. Then, click Next.

4. Choose a file name and a location for your settings file, and click Execute.

5. Click Finish to close the wizard.

Note

The default folder to store settings is C:\Users\UserName\Documents\Devart\dbForge SQL Complete\Settings. If you want to change the location for settings, click Browse, choose a shared folder, and then click Save.

After the profile settings have been exported, other users can import them.

Import the profile settings

1. On the SQL Complete menu, click Import and Export Settings.

2. In the Import and Export Settings Wizard that opens, select Import selected environment settings and click Next.

3. In the Save Current Settings window, select No, just import settings, overwriting my current settings and then click Next:

4. In the Choose settings to import window, click Browse to select the profile file with settings and click Execute.

5. To close the wizard, click Finish.

To open and use the imported file, go to the SQL Complete > Options. In the dialog that opens, select Formatting > Profiles.

Want to Find out More?

• Previous
• Next