Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to Export/Import a Data Source from DataGrip?

I can't seem to figure out how to export a data source configuration in DataGrip (currently on 2016.2 EAP).

I would like to export a handful of data sources and share them with my teammates to make it easier for them to get up and running on DG.

I've tried File->Export Settings (exporting all settings) and did not notice the data source configurations within the resulting jar file.

I seem to recall that in earlier versions of the tool (when it was still called 0xDBE), you could find data source configuration files on the drive and share them that way, but I am unable to locate any at this time.

Perhaps it's not possible?

like image 682
David Farrell Avatar asked Jun 20 '16 20:06

David Farrell


People also ask

How do I copy a database in DataGrip?

Right-click a table and select Copy Table to… ( F5 ). In the Choose Target dialog, type the name of a schema in which you want to create a copy. In the Import <table_name> Table dialog, ensure that mappings are correct and click Import.

How do I import data into DataGrip?

Import data from file There is a dedicated UI for importing DSV (CSV and TSV) files to the database. Click the schema you wish to import data to, and choose Import From File… from the context menu. Then select the CSV file where your data is stored. You will see the Import dialog window.


1 Answers

UPDATE FROM 2021!

Starting from version 2021.1, you can just press Ctrl/Cmd+C on the data source, and then Ctrl/Cmd+V it in another IDE. The clipboard contains XML for the data source, so you can send it to the colleague via e-mail, messenger etc.


It is possible! You need to share a project with your friend — all you do in DataGrip is in the context of a project. If you did not create a new one, everything is under the default project. Look at the gif:

enter image description here

The more detailed information can be found in the tutorial: https://blog.jetbrains.com/datagrip/2018/05/21/copy-and-share-data-sources-in-datagrip/

like image 70
moscas Avatar answered Sep 22 '22 17:09

moscas