Can I insert into Another Database Connection ?

Answered

so i have 2 database server, i want query prod server, and insert into dev server, can i do it in console?

1 comment

@Wirendy
First of all you need to create two separate data sources (https://www.jetbrains.com/help/datagrip/connecting-to-a-database.html). After that open console for each data source and run your queries(https://www.jetbrains.com/help/datagrip/run-a-query.html).

In case you need to migrate result sets, you can copy data to a intermediate file or just use drag-n-drop (or F5)(https://www.jetbrains.com/datagrip/features/importexport.html#export).

Is that what you need?

0

Please sign in to leave a comment.