Is there a way to duplicate an entry in the Connections window?

ETamas

Member
Is there a way to duplicate an entry in the Connections window? I would like to duplicate a folder that contains several subfolders/connections and then make the necessary changes afterward. For example, when duplicating a DB, I would only need to update the DB name in the new set of connections.
Is there a way of bulk change? (E.g. Db name)
 
You can manually edit file user.prefs,
in %USERPROFILE%\AppData\Roaming\PLSQL Developer xx\Preferences\yoursessionname
 
If you hold down the Ctrl key and click on the (+) button, the currently selected connection will be copied to a new entry.
 
Thanks, Fabrice, I tried to edit the connections backup file which is similar to user.prefs, but I had problems with the value of "Number", it seems it is not allowed to give the same valuse. Do you have suggestion for its value? ( I trid with a random non-existing value)
I copied this block for duplicate one connections. Is that correct?:
DisplayName=
IsFolder=0
Number=218
Parent=226
Username=ABC_E_IF
Database=INTEUR
ConnectAs=Normal
Edition=
Workspace=
AutoConnect=0
ConnectionMatch=536870911
ReadOnly=0
Password=X.bjjgdfDvU55kjhgWdB/uGKvhSw==
IdentifiedExt=0
Color=536870911
 
Back
Top