1. Home
  2. Docs
  3. PostgreSQL
  4. Export Database to Source Control

Export Database to Source Control

1. Connect

Connect to the database you wish to export from

Hint:

A test button is available at the bottom right of the screen. This needs to be pressed before we can continue to the next stage.

Any connection issues will be shown in a popup to help diagnose problems.

2. Select

Select the database you wish to export.

You will now have options to select all objects and data, None, Schema Only or Data Only.

Alternatively you may select items individually through the treeview control.

3. gitSQL

Select the source control path you wish to export to.

Review the objects that you wish to export. Press back if you wish to make amendments – otherwise press Run.

When the export is complete, you will see completed items in the object list in the colour green.

gitSQL will create a DB folder, and then a folder inside that which is the database name.

All exported objects will be in their type folders respectively as .SQL files.

The DATA will be exported to the Tables\Data folder.

Thats it!

You are now free to use a source control client or command line to commit your files into source control.

How can we help?