Menu
What is the process to take a backup of all the connection-details (viz. host,port,sid,etc.) in 'oracle sqldeveloper' software.
How can we import these connection details to some other machine ?
278
Step 1: From the menu, click on the Database option and select Export. Step 2: There are multiple options for exporting the data, choose Export Utility Wizard. Step 3: Since we want to export tables so select the Export tables radio button and click on the Next button. Step 4: Select the table(s) you want to export.
The 'oracle sqldeveloper' stores all the connection details in an xml file ie. connections.xml.
If you want to have a backup for the connection details, you will have to navigate to
In windows XPC:\Documents and Settings\<YourUserName>\Application Data\SQL Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\
In Windows 7C:\Users\<YourUserName>\AppData\Roaming\SQL Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\
and take a backup of connections.xml .
Later, if you need to use the same connections on some other machine, you may simply copy the <Reference ...> tags for respective connections.
163
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
