SQL Developer偏好设置存储位置及跨设备迁移咨询

Alright, let's walk through exactly how to move all your SQL Developer preferences—including those table filters, startup script paths, and the object filters you mentioned—to other devices. I've done this a bunch of times, so here's the breakdown:

Where SQL Developer Stores Your Preferences #

The main preference files live in a system-specific folder tied to your SQL Developer version. Here's where to find it for each OS:

• Windows:
  Navigate to C:\Users\<YourUsername>\AppData\Roaming\SQL Developer\<VersionNumber>\system<RandomString>
  Note: Replace <YourUsername> with your Windows username, and <VersionNumber>/<RandomString> with the folder matching your installed SQL Dev version (e.g., 23.2.0/system13.0.0.210.1709)
• macOS:
  Go to ~/Library/Application Support/SQL Developer/<VersionNumber>/system<RandomString>
  Pro tip: The Library folder is hidden by default—use Cmd + Shift + G in Finder and paste the path to jump straight there.
• Linux:
  Head to ~/.sqldeveloper/<VersionNumber>/system<RandomString>

What to Copy to Grab All Your Settings #

To make sure you don't miss anything (table filters, startup scripts, object filters, etc.), you'll want to copy the entire system<RandomString> folder. This includes:

• All Tools -> Preferences configurations (editor settings, startup script paths, database connection details, etc.)
• Table filters tied to your database connections
• The object filters you referenced (the 'O...' ones) which are stored alongside object view metadata
• Custom reports, code snippets, and other personalized tweaks

Step-by-Step Migration Steps #

Follow these to avoid hiccups:

1. Close SQL Developer on both your source (original) and target (new) devices—this prevents file locks or corrupted settings.
2. On your source device, find the system<RandomString> folder using the path above, then copy the whole folder to a USB drive, cloud storage, or directly transfer it to the target device.
3. On the target device, install the same version of SQL Developer as your source device (different versions can break preference compatibility).
4. Launch SQL Developer once, then immediately close it—this creates the initial empty preference folder structure.
5. Replace the newly created system<RandomString> folder on the target device with the one you copied from your source.
6. Fire up SQL Developer on the target device—all your preferences, filters, and settings should be ready to use!

Quick Tips to Avoid Headaches #

• Stick to the same version: Using mismatched SQL Developer versions can lead to missing settings or corrupted preference files. Always install the exact same major/minor version on the target device.
• Backup first: Before replacing the target's system folder, make a backup of the original one just in case you need to roll back.
• Passwords: If you want to transfer saved connection passwords, you'll need to copy the sqldeveloper.conf file from your source's SQL Developer installation directory to the target. Make sure the ide.password.encryptionKey line is identical in both files. If that sounds too fussy, it's easier to just re-enter passwords manually after migration.

内容的提问来源于stack exchange，提问作者TomB