Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Oracle Sql Developer connections storage

Where does Oracle SQL Developer-3.2.20 store connections?

It used to be in IDEconnections.xml but in the latest version I do not see this file.

like image 908
user1980265 Avatar asked Mar 12 '13 12:03

user1980265


2 Answers

I'm using 3.1.07 and it's stored under:

C:\Users{user}\AppData\Roaming\SQL Developer\system3.1.07.42
\o.jdeveloper.db.connection.11.1.1.4.37.59.48\connections.xml

Replace the sqldeveloper version with your own and you should be able to find the correct folder.

Else you can always right-click on Connections in the Connections view of SQLDeveloper and select Export connections.

like image 100
JWK Avatar answered Nov 10 '22 12:11

JWK


SqlDeveloper stores all the connections in a file named

connections.xml

In windows XP you can find the file in location

C:\Documents and Settings\<username>\Application Data\SQL Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\connections.xml

In Windows 7 you will find it in location

C:\Users\<username>\AppData\Roaming\SQL Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\connections.xml
like image 32
Aniket Thakur Avatar answered Nov 10 '22 12:11

Aniket Thakur