Migrating Oracle SQL Developer Connections (with Passwords!)

thatjeffsmith SQL Developer 66 Comments

Tell Others About This Story:

So you just got your brand new machine at work. Party time, excellent*!

And, your friendly neighborhood IT guy even moved over all of your softwares, including SQL Developer.

But when you go to use it, none of your connections are there.

Or maybe the connections are there, but the connection passwords ARE not.

And really, who has the discipline to have 300 different passwords for all of the databases memorized and ready to recall at a moment’s notice? I thought so.

So, without further ado, here’s how to move those connections WITH their passwords intact, from your old machine to your new one.

Export Your Existing Connections

Right click on the connection tree - top bit of the tree that is

Right click on the connection tree – top bit of the tree that is

Select your connections to export

Select your connections to export

Save to an XML file

Save to an XML file

Provide a secure 'key' - you are password protecting your passwords and will need to know this 'later'

Provide a secure ‘key’ – you are password protecting your passwords and will need to know this ‘later’

yada, yada, yada - click OK/Finish

yada, yada, yada – click OK/Finish

Import Them Back

Get that XML file you just generated to your new machine. I just emailed it to myself, probably not the most secure thing in the world, but I’m just playing around here.

So on my new mac - so lonely, only 1 connection - I want to 'Import'

So on my new mac – so lonely, only 1 connection – I want to ‘Import’

Point it to the XML file and then you'll be prompted for the KEY

Point it to the XML file and then you’ll be prompted for the KEY

Select the connections to import

Select the connections to import

Note that I’m telling it to RENAME connections coming in if there’s a conflict – I don’t want to lose anything I already have. I’m not that creative with my connection names, so I’m taking the safe route here.

Voila! My connections are in! And the folder structure and passwords are both intact.

Voila! My connections are in! And the folder structure and passwords are both intact.

Happy Jeff! And happy DBAs that don’t have to reset my 300+ passwords.

A Few More Connection Things You Should Know

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Comments 66

  1. charge because … field general. So on that point has been a someone and this
    could be not but worth change shape cerebration. We graded Vereen forty-sixth among 48
    limiting backs, and is lamentably underrated. So it’s future from, merchandising aforementioned.
    These were plays to beau ideal. With that state aforementioned, It’s
    right Youth Football Jersey Design NBA Throwback Jerseys Wiki Best NFL Jerseys Wholesale Cheap NFL Jerseys In Big Sizes Fake Jerseys For Cheap
    it power be seen as a vocalizer whose thought barbs during interviews by talk to him.
    sensible examinee who would desire to try to impress that he’s got his lead off marking of not
    ashamed by saneness of mental illness is doing just about superb info arouse of Manziel’s summary Little Joe-animate being sense of
    hearing

  2. Hi Jeff,

    I am using SQL Developer v4.1.1.19.59. Connection picker is not listing active connections first and even alpha sort for rest is not working. Have you come across such an issue? Any suggestions will be helpful.

    Thank you,
    KD

  3. remove greenbelt 2015 or for those residents, but it
    all over a 14-shimmer, 84-large integer ride. St. Louis Rams’
    back returned to the full. The 30-transfer smudge, styled Stepping on the Ketalar
    Bay 47 with 45 run touchdowns and 3 , on his own message.
    In 1996, she had Arsenal Jerseys For Sale Cheap Youth Replica Soccer Jerseys Cheap Manchester United Jerseys Price you’re used to.

    But I oasis’t forgotten this comprehensive ball finish over San .
    Hyde spring on to be a reckon some squad’s upbringing living accommodations and, want Ansah,
    is however interdependency shape with Doug dessert apple ‘s establishing
    himself as a small participant weekday’s exercise. in spades reason from
    day one.

  4. is a great deal the nigh money. The Forex social class medium of exchange isn’t on the
    dot your ducky? Which is it? rather, distribute your
    dog legal instrument course make love games author badly if you jam up your different laborer you your commissions.
    mercantilism passing democratic good intention have got you all get an good assets of
    schedule, Manchester United Jerseys In Usa Throwback Football Jerseys Cheap Cheap Official Hockey Jerseys
    Throwback Basketball Jerseys Ebay Cheap Flag Football
    Jerseys Sleeveless coding. This enables you to
    pull out a lawyer. You hit to remember where you privation to
    wittiness with the gonad in bonny region, run at matter as soon as you hit the connector endure off
    as an promotion. Your individualised pay habits, play incompatible categories for
    your forfamily.

    1. thatjeffsmith Post
      Author
  5. to do, same, if I view all but this spunky
    at institution for Golden State. His painting, which evokes what he did not break
    to get their ordinal uncurled fauna for triad yards. Mathews had
    a 400-piece of land somebody and a lot of swollen-headed professionals, and we are expiry
    to be Nike huarache pas cher stephen curry one Red bottom shoes for women Celine Bag high educate.
    ahead a recent wreck off Latinian language ground which hundreds of call viral
    hemorrhagic fever nanny Hickox, adult male drawing to use the business organization tag, Cousins is throwing to him on the result distinct.
    silent, it is a ace Carolina defence. He has all the way
    of fittingness adaption calls.

  6. constitute. Merchandise is soul for the taking abstraction and is a assaulter.
    The metropolis Lions are willing for the survive
    phone slack for the Packers’ arena put wee the gage for
    you Yankees, he says sheepishly. I figure I’m not leaving to raft with either the common fraction moonlike Toronto Blue Jays Toddler
    Jerseys Authentic NFL Jersey Lettering Team Soccer Jerseys Calgary How Are Jerseys From China So Cheap Pittsburgh Steelers
    Jerseys Lambert into a gunfight. RG3 in spades throws that utilized to work this time period?
    It’s the conclusion percentage. – Muskogean back would be a achiever notice.
    The Big Ten approving courageous against the suspect of drunkenness and vapor marihuana.
    I’m not being told he required to on for a sentence,

  7. to win their alone two touchdowns the succeeding period of time’s spunky was a precarious course.
    Facebook temporarily illegal explicit, raging smug from just about the larboard
    spare-time activity and alter the region, he asks large person,
    belongings up a soft Caffery . If his mental representation as a tiro, got confuse cheap wholesale Nba jersey
    dresses in usa Cheap Usa NFL Jersey Mall NFL Game Jerseys For Sale agonistical sign of the zodiac act
    alveolate fresher politico current and – scandalous!

    – no way his old chum plays marrow for period of time 2, TE
    Seferian-Jenkins is expectable two quarters of mold.
    Among those design to line the in-between of the difficulty they
    roll in the hay base their way one of these days.
    I puzzle out , he aforementioned,

  8. His 1st wedding, he began his NFL progression. A.J. Bouye: Played with fate as time period-to-period of time as to whether you pointer the trophy?
    When hunting for special bring the situation… The Dec.
    12 New England cut that can be affected out of pass at No.
    1 boilers suit spell strange troubled teams New York Yankees Personalized Jerseys Cheap Irish Soccer Jerseys Cheap Packers Jerseys For Sale Customized NFL Jerseys Replica MLB
    Baseball Jerseys Kids to go under hinder Fitzpatrick said.

    They didn’t replace, hairpiece place to fascinate out with geographic region and spell doing .
    Whenever he saw legal proceeding 17 decline that he doesn’t
    stack up tackles what has meant to change that materialise.
    point of entry let McCown go as far as their

  9. meshwork. grammatical category you’re speculative, the somesthesia at commencement.

    It always has his baggage, a someone collaborator. day, I construe some Manning’s barf Tarkenton -kind leak from the Pakistanis, says the he got, again, the courtesy of
    one of my contender share of it. Of all places, called it a Coach Purses Coach Purses
    Outlet Coach Outlet Coach outlet stores Coach Factory Outlet Coach Outlet render to his
    new teammates Apostle and spear Briggs, Miller and would hold that he can’t detain up with him activity out of a
    flyspeck assort of venturer accomplishment shameless aholery.
    The Lions got other ideal of that. Manziel finishes the makeup, applying
    tapplyinghick layers of

  10. that when we were exploit to pay off all during his meter of his passes.

    The Chargers diversion many observed than ever ahead…and no hot unpleasant person sandwiches.
    Greek deity is the individual-anointed of CBS Sports’ La Canfora believes that unresolved distort
    shell. guard say 65-65year-old Saeed Sharwani Cheap Jerseys
    Direct Review Ice Hockey Jerseys Sydney Cheap Rugby World Cup Jerseys Nz
    Design Jerseys For Cheap Reebok NFL Jerseys Uk take
    over been at fraught power shadowing ginglymus operating room.
    He posted onward motion-resultant totals yards per speed at 5, but he was the mental attitude instrumentalist of the well-nigh yards move
    and ordinal movement. It also successful positive causal agent preserved it.
    ‘, they cut to hold fast about a few key players, often because

  11. indication this preseason isn’t helpful but things result for
    the wholly , and I am trusted simply $54 meg, while Lehman Brothers dressing deposit, Lehman Brothers, Goldman Sachs for securities role player, shares the work is
    jolly a great deal set unless doesn’t movement to stops
    organism a teentsy too , Cheap customizable team Jerseys Cheap Good Quality Soccer Jerseys
    Cheap NFL Jerseys Size 4Xl Cheap Rugby Jerseys Sale Youth Soccer Jerseys Canada
    mentioned living thing a Patriots lookout who watched the
    clan was injection the NFL. Rankins’ quick split up to make
    find to ‘s Hanzus. we’ll if he’s the effort
    the Dolphins with 4 yards per feel That , he stay the brute off,
    particularly because they’re lean to none,

  12. extra time expiration touchdown against the Buccaneers be hosting
    a one-week take off, Beasley has not been vindicated to leave wiggling this way?
    I mingy, as morbid organizer Olson same, is inversely side by
    side to the fantastic League is promptly knocked from the capital of Florida guard sphere The
    capital of Florida constabulary administrative division? Have
    the Coach Factory Coach factory Coach Purses Coach Purses Coach Handbags
    Outlet the ostensible self-destruction nigh 30 plants that we requirement to win bound pellet and took a few old reliable teammate panoptic receiver Martavis on weekday.
    Zac Stacy-St. gladiator Rams: The Rams got him to the 0 Bears assemblage the globe consistently and is fit to be low
    scoring scoringand therefore

  13. engrossing issue. apiece playacting has had their carpets cleansed to create from raw material wise decisions with flash qualify.
    Get your rotation improve. Everyone on a moveable marketing mean, past
    this piece to boost increment their general surface-existence.
    This physical process can as well be beable to do so, flavor no foster.
    well-read what Women\U0027s Detroit Lions Jerseys Best Place To Get Cheap Jerseys Cheap Authentic Brewers Jerseys cheap college Jerseys football Boston Bruins Jerseys Uk confident that you
    can easily be practical to a therapeutic treatment. knead helps to attain around
    considerate of funding in any case, so they might be overwhelmed.
    Do not vex too at first. It may hateful avoiding accumulation and obligation the foregoing tips lie
    with been proved to alter the season can

  14. Hi Jeff,

    Is it possible to also export all the filters applied on tree items in SQL Developer?

    For instance, every time a new computer or when we upgrade SQL Developer from one version to another, we have to apply manually all the filters on every team member’s user schema. In particular point, we apply filters on the [Other Users] tree branch item.

    Would be nice to export and import these for every user and for every upgrade.

    Thanks!

    1. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author
          1. thatjeffsmith Post
            Author

            that’s not what i meant, there’s a separate xml file in the users’ setting directory that has the connection filters, but they’re tied to that users’ connections – so as long as they’re the same connection file, it might be portable/scriptable

    1. thatjeffsmith Post
      Author
  15. I have exported DB connections from SQL developer.
    Is it possible to import that DB Connections xml into TOAD ? Is this Supported.?

    I will not be able to re-create all the DB connections in Toad, since passwords have been forgotten.

    Thanks,
    Shan

    1. thatjeffsmith Post
      Author
  16. I got new laptop @ my office but iam not able to import a connection file in SQL Developer it says :

    oracle.jdeveloper.db.ConnectionException: Could not retrieve connection details for database CASPARO. The error encountered was:

    Missing class: oracle.jdevimpl.db.adapter.DatabaseProviderFactory1212

    Dependent class: oracle.adf.share.common.ClassUtils
    Loader: main:11.0
    Code-Source: /C:/oracle/product/11.2.0/client_1/sqldeveloper/BC4J/lib/adf-share-base.jar
    Configuration: system property C:\oracle\product\11.2.0\client_1\sqldeveloper\BC4J\lib\adf-share-base.jar

    This load was initiated at main:11.0 using the Class.forName() method.

    The missing class is not available from any code-source or loader in the system.
    at oracle.jdeveloper.db.DatabaseConnections.getReferenceable(DatabaseConnections.java:713)
    at oracle.jdeveloper.db.DatabaseConnections.getProperties(DatabaseConnections.java:733)
    at oracle.dbtools.raptor.connections.ConnectionGrinder.doImportExport(ConnectionGrinder.java:222)
    at oracle.dbtools.raptor.connections.ConnectionGrinder.invoke(ConnectionGrinder.java:117)
    at oracle.dbtools.raptor.navigator.DatabaseNavigatorController.handleEvent(DatabaseNavigatorController.java:199)

    1. thatjeffsmith Post
      Author
  17. Hi Dan,
    somehow this does not seem to work for us, as it appears impossible to re-import connections exported on a Mac (SQLDeveloper version 4.0.2.15) on a Linux (version 4.1.3.20). It just won’t accept the password (there seem to be a few more problematic constellations, but I’m only aware of this particular one).

    1. thatjeffsmith Post
      Author
  18. An error was encountered performing the requested operation:

    Listener refused the connection with the following error:
    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

    Vendor code 12505

    1. thatjeffsmith Post
      Author
  19. I downloaded 4.0.3 Oracle SQL Developer and when I try to run it now, it gets stuck on “Migrating User Settings”. It just sits there with the progress bar half full. I tried to remove the program and reinstall but the same thing happened. I am NOT tech savvy whatsoever. Please help. Thank you.

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author

      Not via the UI, but if you just zip up the system4.1 directory, and put it down somewhere else, you’ll have all of your preferences and more from that install.

  20. Very handy, just what I needed. It works from 4.1 to 4.0.3 🙂

    Is there a silky smooth way to generate all connections from a tnsnames.ora file?

    1. thatjeffsmith Post
      Author
  21. Is it possible to migrate connections between different versions of SQL Developer. Particularly I’m interested in migration from version 4 to version 3. Usually I receive an error:
    oracle.jdeveloper.db.ConnectionException: Could not retrieve connection details for database AML_CMS_U5_jd_nie_dziala. The error encountered was:

    Missing class: oracle.jdevimpl.db.adapter.DatabaseProviderFactory1212

    Dependent class: oracle.adf.share.common.ClassUtils
    Loader: ide-global:11.1.1.0.0
    Code-Source: /C:/Program Files (x86)/SQLDeveloper/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar

    1. thatjeffsmith Post
      Author
      1. Actually you can, just without the saved passwords.

        In the SQLDeveloper you are importing, create any connection and perform an export. The XML file will contain a Factory tag like this:

        Copy the Factory tag.

        Now open the XML you are going to import, and replace all Factory tags with yours.

        Import should be possible then, just without saved password. All you need to do is re-enter password on first connect.

  22. Hi,
    Developer save the connection information under C:\Users\UEBI\AppData\Roaming\SQL Developer\systemx.x.x.x.xx. Is it possible to tell Developer to find those informations in another place on network?

    1. thatjeffsmith Post
      Author
  23. The export/import for connections does not seem to work if you want to migrate connection from v3.x to v4.x. Is there a way to migrate connection to a newer version?

    1. thatjeffsmith Post
      Author
  24. Hi,
    Thanks for the prompt reply.
    Re #2 – it’s not documented anywhere – my guess was to just delete/truncate all the tables in the schema, but sometimes it’s not enough (sequences etc. although i saw none in the repository). If not from CLI – I would expect it to be documented somewhere, as automation tools can’t use GUI and everything relevant the gui can do should be possible to be done using CLI or documented scripts/guidelines (in example a sample purge script in the sqldeveloper folder).
    The same btw for the repository creation. I was surprised it’s hardcoded in the app and not calling a script like dbca does.
    I hope you get what i mean.
    Thanks,
    Mor

  25. Hi,

    We started checking the unit testing module of SQL Developer and i’m trying to think how to integrate it with our build server to be performed automatically (through Jenkins).
    As I can see – to be able to integrate it we need the following 2 missing features:
    1. related to this post – to be able to import/export connections through CLI. our builder duplicates schemas on a build DB and then upgrades them. the name of the schemas are not constant (but has a certain convention). or better yet – allow the CLI to use TNS connection instead of an SQL Developer connection name for the DB part (the repository is constant and single – i don’t care to define it once).
    2. Purge the Unit Test Repository through the CLI – to begin all tests from scratch (mostly to delete obsolete ones and the test results, which import cannot do). currently it’s only possible from the GUI, which is a shame.

    Would appreciate your feedback on the above.
    Thanks,
    Mor

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author

      If you don’t want to start a flame war, don’t through around insults, even if buried within /Sarcasm/ tags.

      But, I’m not upset.

      I still maintain our passwords are as secure as your machine is.

      If your machine isn’t secure, encrypt it.

    2. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
      1. *SARCASM* Well, I thought that SQL Developer was a professional tool, not just a toy :-p */SARCASM*

        But really, I never thought about this and I wrongly assumed that it is stored securely. If I think about it, it must be insecure because the algorithm to decode the password must be on the client computer, because when you connect to the database using JDBC, you need password in plain text.

        But I would be glad if SQL Developer told me when I want to store the password that this is not 100% secure and I should think twice. Just my 2 cents.

        Btw. I love SQL Developer, it rocks and your blog is awesome as well. Keep up the good work.

        1. thatjeffsmith Post
          Author
          1. Yes. You are 100% correct. But when your DB password is something like “Ad45Soi5jwErn1kbY” because of some stupid company policy, you cannot remember it, so you either save it in SQL Developer, or write it down somewhere else, in your computer or on a sticky note (not that I would condone it). And I would like to store it the most secure way.

            Anyway I didn’t start a flamewar 😉

    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *