Is there a way to configure the directory SQL Developer uses to save SQL scripts?

sqldeveloper

70,174

Solution 1

Found it ...

In the Choose Directory dialog, the left hand side has a number of commonly used short cuts, e.g. Desktop, Documents, but you can also have your own directories in there

Solution 2

Change it in Tools > Preferences > Database > Worksheet parameters. You can browse to a new location under "Select default path to look for scripts"

Can also change the Export Data so that it defaults to somewhere else. Go to Tools>Preferences>Database>Export and Browse to the location you want to export to for "Directory".

Solution 3

There is a post about this in OTN, and AlexAnd's solution opens the specified folder when I do File => Open.

The post is @

https://community.oracle.com/message/9733247#9733247

AlexAnd is saying that locate "\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf" and simply add "AddVMOption -Dide.user.dir=" (where " is the full folder path that you like to use) to that file.

The disadvantage of this solution is that it will also move your settings folders to the specified folder (for me it was about 34MB), I use drop box to keep my queries so that is a wasted space.

70,174

kailash gaur

Contracting in anything interesting with Microsoft technologies, primarily middle/back-end in C#, BizTalk, Azure, SQL Server, WCF, SSIS, etc. Currently working at Wokingham Borough Council on integrations using Dynamics CRM Online, Azure Service Bus and various back office systems. Please feel free to contact me if you've got an interesting project ...

Updated on September 18, 2022

Comments

kailash gaur almost 2 years

Is there a way to configure the directory SQL Developer uses to save SQL scripts?

When I do ... File, New, SQL File ... the directory is always set to the \AppData\Roaming\ for my user.

I'd like to set the default to a directory in my dev source code tree.
- surfasb over 12 years
  
  If it is hardcoded, you should think about just dropping a symlink to your desired directory in Appdata\roaming.
- kailash gaur over 12 years
  
  Checked the registry and can't find any setting
Ravindra Bawane over 7 years

That's standard behavior for every Open or Save dialog.
luke over 6 years

It changes the place where settings are stored. Connections are stored in this directory by default, but if you want to make sql developer store scripts in this directory you still have to go to Tools>Preferences>Database>Worksheet and change "Select default path to look for scripts".
Máté Juhász over 4 years

The question is about default location for SAVE, not for open.