How to Export Connections in SQL Developer

SQL Developer stores details about database connections. It also has the ability to export connections, which is helpful if you ever need to change computers, or if you want to share the connections with your development team.

To use SQL Developer to export connections, right-click on the Connections item and select Export. Follow the steps, including selecting a filename, and indicating how you want to treat passwords.

A JSON file will be created which contains all of the data about the connections, and the passwords will either be removed or encrypted, depending on what you selected.

The connections file can then be shared for others to import, which I have created a separate video for.

Timestamps:
00:00 Introduction
00:30 Right-click then Export Connections
00:47 Select connections
01:15 Output file
01:54 Encrypt or not
02:45 Summary
02:57 JSON file example
03:25 More information

[houstonfirefox]

This is a real time-saver if the team is large and/or there are many instances in the organization. On the SQL Server side of things we utilize a shared Central Management Server (CMS). Keep up the great work!

[ankitajoshi]

How to export details in XML file, please tell