Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Where are saved snippets?

989402Feb 6 2013 — edited Nov 6 2013
Hello everyone!

I am using Oracle SQL Developer at work and at home. I want to share my snippets between these two computers with for example Dropbox.
Could you tell me in which folder snippets are saved.

Greetings
Slawek

Comments

user13430807
Hello Slawek,

you can find the user snippets on Windows in:
c:\documents and settings\<user>\Application Data\ SQL Developer
The file is called UserSnippets.xml

Best regards,

Joop
1 person found this helpful
989402
Thank you for help.
On my computer (Windows 7) this file exists in:

c:\Users\<USERNAME>\AppData\Roaming\SQL Developer\

greetings!

[Edit]
Solution for everyone who uses Dropbox and wants shared snippets between computers (Windows 7).

1. Copy "SQL Developer" folder from c:\Users\<USERNAME>\AppData\Roaming\SQL Developer\ to "Dropbox" folder.
2. Remove "SQL Developer" folder from c:\Users\<USERNAME>\AppData\Roaming\SQL Developer\ [*command: RD /S /Q "SQL Developer"*]
3. Create folder symlink "SQL Developer" -> to -> "SQL Developer" in Dropbox:
a) Go to c:\Users\<USERNAME>\AppData\Roaming\
b) In cmd (+as administrator+): [*command: mklink /D "SQL Developer" "c:\Dropbox\SQL Developer"*]
c) Run SQL Developer.
4. Do the same on another computer.

Not only snippets are synchronized, connections, templates also.

Greetings
Sławek

Edited by: 986399 on 2013-02-06 12:45

Edited by: 986399 on 2013-02-06 12:58
1 person found this helpful
jkoradba

This works.  Thanks!

The only concern I have is whether SQL Developer is designed to handle network or cloud storage of these settings while SQL Developer is open from another location(s).  Perhaps it is.  It is seems that settings, e.g. a new database connection, don't  become available at the other computer until exiting from SQL Developer on the computer where the change was made.

Yes, you'll be fine, mostly.

Files are generally written on application shutdown.

My only caveat, in version 4, passwords won't be transferable, so your connections will carry over but the passwords will not.

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 4 2013
Added on Feb 6 2013
#sql-developer
4 comments
3,378 views