4 Replies Latest reply: Nov 6, 2013 3:00 PM by Jeff Smith Sqldev Pm-Oracle RSS

    Where are saved snippets?

    989402
    989402 Feb 6, 2013 1:37 AM
      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
      • 812 Views
      • Tags:
        • 1. Re: Where are saved snippets?
          user13430807
          user13430807 Feb 6, 2013 3:55 AM (in response to 989402)
          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
            989402 Feb 6, 2013 2:59 PM (in response to user13430807)
            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
              jkoradba Nov 6, 2013 1:19 PM (in response to 989402)

              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-Oracle
                Jeff Smith Sqldev Pm-Oracle Nov 6, 2013 3:00 PM (in response to jkoradba)

                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.