Post

Just had to migrate some of my connections from SQL Developer to VS Code (SQL Developer extension). Very easy and straightforward: 🔸 Right-click the top-level Oracle Connections node in SQL Developer’s Connections panel. 🔸 Select Export Connections and choose the connections to migrate ... ⤵️

Plamen Mushkov

@apexapplab.dev

4 Mar 2025

🔸 Protect the export file with a password to encrypt sensitive credentials. Save the file (e.g., SQLDev-connections.json) to a location on your machine. Ensure SQLcl version 23.3 or later is installed. This is bundled with both SQL Developer and the VS Code extension. ⤵️

Plamen Mushkov

@apexapplab.dev

While in VS Code, open a Terminal window and launch SQLcl in nolog mode: ▶️ sql /nolog Then store the export file’s password in SQLcl’s secret manager: ▶️ secret set myExportPass MyExportPassword Import the JSON file: ▶️ connmgr import -key myExportPass /path/to/SQLDev-connections.json 🎉🎉🎉

4/3/25, 1:33 pm0 reposts1 like

No replies yet.