In DataGrip these secondary objects are hidden under two nodes: Server Objects and Database Objects. People are constantly working with tables, views, and routines, but users, roles, tablespaces, foreign data wrappers, and many other object types are not used as frequently. You can also use Ctrl+C, Ctrl+V, and Ctrl+X ( ⌘+C, ⌘+V, and ⌘+X for MacOS) to copy, paste, and cut your data sources between folders. The same works when placing the data source into an existing group – just drag-and-drop it there. To create a new group, just drag one data source onto the other. Press F6 or choose Move to group in the context menu.ĭrag-and-drop also works for creating groups in the database explorer. When you’re working with a large number of data sources, it can be convenient to group them, just as you would do with folders on your computer. For instance, ‘ fa‘ is enough to find ‘ film_actor‘. Note that speed search works only for expanded nodes. You can use the arrow keys to navigate through the matches. The matching part of the string is highlighted. Just start typing! As you type, a text field appears over the database explorer window, the entered characters are displayed, and the selection moves to the first item that matches your search query. The only thing you will need to specify again is the password, because that isn’t copied with the data source. You can then just paste this XML snippet as a new data source in a database tool window inside the same IDE or in another JetBrains IDE ( Ctrl+V for Windows/Linux, ⌘+V for MacOS). Put the cursor on the data source and press Ctrl+C/⌘+C, and an XML snippet will be created on your clipboard. Just use Ctrl+C, Ctrl+V, and Ctrl+X ( ⌘+C, ⌘+V, and ⌘+X for MacOS) to copy, paste, and cut your data sources, respectively. Duplicating or creating a similar data source.Distributing data source settings among team members.Easy copy-pasting of data sourcesĬopy-pasting data sources can be useful in the following situations: Here are the advantages of the DataGrip database explorer that our users value most. It supports PostgreSQL, MySQL, SQL Server, Oracle, MongoDB, and many other databases and DDL data sources. You can view the structure of your databases and perform other tasks in the database explorer. JetBrains DataGrip is a powerful tool for working with databases.
0 kommentar(er)
