Script schema of the entire database with Datagrip

datagrip
vittore picture vittore · Jul 27, 2016 · Viewed 9.9k times · Source

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?

Answer

RobbZ picture RobbZ · Aug 31, 2016

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.

Related questions

Creating new database in DataGrip JetBrains

Anybody know how to create new database in DataGrip (database IDE from JetBrains)? Could not find in DataGrip Help page.

Read More
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 …

Read More
How to export a data base from DataGrip at one SQL file?

How I can export a data base from DataGrip at one SQL file as phpmyadmin export? If I use Dump Data To Files, DataGrip save one table at one file. And how I can create backup of all MySQL databases, …

Read More