Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

(datagrip) Database connection with multiple schemas

I'd like to know if it's possible to manage multiple database schemas with just one connection in [datagrip]. Has anyone experience with that?

like image 990
Jan Schumacher Avatar asked Oct 06 '15 07:10

Jan Schumacher


People also ask

How do I show all schemas in DataGrip?

Show all the schemas and databases To display all the available databases and schemas in the Database Explorer (View | Tool Windows | Database Explorer), click the Show Options Menu button and select the Show All Namespaces option.

How do I import a schema into DataGrip?

In the Database Explorer (View | Tool Windows | Database Explorer), right-click a schema or a table and select Import/Export | Import Data from File(s). Navigate to the files that contain delimiter-separated values, select them, and click Open.

How do I compare two databases in DataGrip?

In the Database Explorer, select two database objects and press Ctrl+D . Compare Content is available in the context menu for tables, views, and materialized views.


1 Answers

Right click on your database connection, and then click properties, you can choose schemas in schemas tab. Select your schemas, and then you must right click on your database connection again, and click synchronize. You will find your schemas.one two

like image 168
zhoujunfu Avatar answered Sep 20 '22 18:09

zhoujunfu