Script schema of the entire database with Datagrip

Question

Is it possible to script schema of the entire database (SQL Server or Postgres) using datagrip?

I know I can get DDL for table and view and source for each stored procedure / function on it's own.

Can I get one script for all objects in database at once?

Alternatively, is there a way to search through code of all routines at once, say I need to find which ones are using #table temp table?

score 10 · Accepted Answer · answered Mar 15 '19 at 09:48

From 2018.2 there is a feature called SQL generator. It will generate the whole DDL for the database/schema with several available options.

The result is:

BUT: If you want just to understand where the table is used, please use the dedicated functionality which is called Find Usages (Alt+F7 or context menu on a table name)

score 7 · Answer 2 · answered Aug 31 '16 at 10:01

7

I was looking for this today and just found it. If you right click the schema you want to copy and choose "Copy DDL" this will copy the create script to the clipboard.

answered Aug 31 '16 at 10:01

RobbZ

1,410
14
19

2

well, on first look it does, however it have one serious limitation: all stored procedures are scripted as `CREATE PROCEDURE usp_RequestFileDelete(@FileId INT);` i.e. no code ( at least for Sql Server) – vittore Aug 31 '16 at 11:29
That's a shame. I am using Datagrip only with Amazon's Redshift. I use SSMS whenever I have to work with Sql Server. SSMS is excellent if you add SQL Prompt or SQL Complete. – RobbZ Aug 31 '16 at 13:09
same thing, love my sqlcomplete. was hoping to have native OSX tool, so i dont need RDP to my pc just to do some DB stuff. Aparently cant do all the things i need. – vittore Aug 31 '16 at 13:17

score 2 · Answer 3 · answered Feb 09 '17 at 07:54

2

To answer your second part of the question: quick and easy way to search for #table in all of your procedures you can do the following query

SELECT *
FROM information_schema.routines
WHERE routine_definition LIKE '%#table%'

answered Feb 09 '17 at 07:54

Arno Venter

51
3

score 1 · Answer 4 · edited Jul 29 '16 at 11:05

1

For now only dumping tables works. In 2016.3 EAP which will be available in the end of August there will be an integration with mysqldump and pg_dump.

Check the screenshot

edited Jul 29 '16 at 11:05

answered Jul 29 '16 at 11:02

moscas

9,064
36
42

1

That does not answer my question at all. I am interested in schema, not data. – vittore Jul 29 '16 at 14:51
added clarification to the question, to avoid further confusion. – vittore Jul 29 '16 at 15:00
2016.3 will be integrated with mysqldump and pg_dump – moscas Aug 01 '16 at 09:37

Script schema of the entire database with Datagrip

4 Answers4