FB

How To Use The SQL Developer Export Connections With Passwords Function

Oracle’s SQL Developer tool lets you export a list of connections that you have created. This is great for saving time for your team. Learn how you can do that in this article.

Why Export Connections?

First of all, why would you want to export your connections?

There are a few reasons I can think of.

  1. Keep a separate file that contains your connections in case your computer crashes
  2. Save time setting up your computer if you get a new one
  3. Sharing common connections with the rest of the team so they can easily import and use the same connections

Let’s take a look at how to export connections in SQL Developer.

 

SQL Developer Export Connections Process

In short, to export connections in SQL Developer, the steps are:

  1. Open SQL Developer.
  2. Right click on the Connections item in the Connections tree, and select “Export Connections…”
  3. Select the connections you want to export.
  4. Specify the output file.
  5. Select either encrypt passwords or remove passwords.
  6. Click Finish

Your passwords are then saved in the specified file.

Let’s look at these steps in more detail. I’m going to assume you have at least one connection created in SQL Developer.

If you don’t you can read my guide or watch my video on how to set up a connection in SQL Developer.

In the image here, I have three.

connection 01

Now, to find the SQL Developer Export Connections menu option, right click on the Connections item in the tree, and select Export Connections…

connection 02

The Export Connections wizard will appear.

connections 03

Select the connections you want to export by clicking in the checkbox next to each item. You can select all items by clicking on the top-level Connections item, which is what I have done.

Then, click Next.

While you’re here, if you want a helpful list of ways to save time with Oracle SQL Developer, get my PDF guide here:

You’ll then be asked for an output file.

connections 04

You can enter the full path name for the file (location and filename), or click on Browse.

connections 05

Find the location where you want to save your connections file, and enter a filename. Connections are saved as an XML file, and I’ll show you an example later in this article.

Click Save.

Now, click Next.

You’ll be asked if you want to encrypt passwords or remove passwords.

connections 06

This is an important step, as you don’t want passwords in free-text fields in your exported file. You have two options

  • Encrypt all passwords with a key. You enter an encryption key to use, which you’ll need to enter again in the Verify Key box.
  • Remove all passwords from the exported connections. This removes the passwords, which means you’ll need to re-enter them when you go to use them.
I personally prefer the encryption option, as it saves time. If you’re OK with this, select this option. Enter a key in both boxes and click Next.

The Summary is shown. Click Finish.

connections 07

Your connections file is created, which is an XML file listing all of your connections.

connections 08

So, that’s how you use the SQL Developer Export Connections function.

While you’re here, if you want a helpful list of ways to save time with Oracle SQL Developer, get my PDF guide here:

8 thoughts on “How To Use The SQL Developer Export Connections With Passwords Function”

    1. Good point! You can follow similar steps to import this connection file in SQL Developer, but I can add that to this article.

  1. Ramprasad Guvvada

    Hi,

    I am using sqldeveloper 19.4 and while exporting Database connections, I could not find XML format. It shows only JSON format..

    Please help me what is missing here and what needs to be done to get the connections in XML format.

    1. The later versions of SQL Developer uses json instead of xml. The process to export and import is essentially the same.
      These versions of SQL Developer save the onnectionsin the file
      “C:\Users\\AppData\Roaming\SQL Developer\system\o.jdeveloper.db.connection\connections.json”

  2. Fernando Escobar

    Hello, Ben. Thank you very much for this article. What would be the “formation rule” for the Encryption Key?

  3. Thank you! Is there a way to do it dynamically via cli or something? Also, does anybody know to build connections list dynamically with encrypted/decrypted passwords?

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.