How to transfer data sources to another computer

Question

How to export previously created data sources to another computer?

Answer

Exporting and transferring data sources created in DataGrip or with the Database Tools and SQL plugin in other IDEs can be done in several ways. For full instructions, refer to the Share data sources guide. In short, the following options are available:

• Copy data sources to clipboard by pressing Cmd + C /Ctrl + C and transfer the resulting XML from the clipboard to another computer. In the target IDE, press Cmd + V /Ctrl + V to insert the data sources. This is typically the fastest method.
• Locate the dataSources.xml file and copy it to the corresponding location on the new machine. Alternatively, you can transfer the whole project folder, including the hidden .idea folder, and open the copied project on the new computer.
• Make the data sources global, then export global data source settings to a ZIP archive via File | Export Settings with selected Database: global data sources, and transfer the ZIP to the new computer. On the target machine, use import global data source settings from a ZIP archive via File | Import Settings. This method allows transferring not only configured data sources but also custom IDE configurations.

Note: Transferring saved passwords requires an extra step. To do so, you must also copy the KDBX file to the new machine. See the Share all the connections with passwords section for details.