This discussion is archived
4 Replies Latest reply: Nov 6, 2013 1:00 PM by Jeff Smith SQLDev PM RSS

Where are saved snippets?

989402 Newbie
Currently Being Moderated
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
  • 1. Re: Where are saved snippets?
    user13430807 Explorer
    Currently Being Moderated
    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
  • 2. Re: Where are saved snippets?
    989402 Newbie
    Currently Being Moderated
    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
  • 3. Re: Where are saved snippets?
    jkoradba Newbie
    Currently Being Moderated

    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.

  • 4. Re: Where are saved snippets?
    Jeff Smith SQLDev PM ACE Moderator
    Currently Being Moderated

    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points