Running for the first time
You will need to provide the path to the
bin directory for your Postgres installation by pressing
Locate and navigating to the correct directory:
This can be later changed by navigating to
Help > Settings.
gitSQL has three main screens
- 1 Connect
- 2 Select
- 3 gitSQL
The first step is to add database credentials for the database you wish to export from or import to.
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.
A dropdown control will show containing a list of available databases.
You must select one from the list to load a list of objects.
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.
N.B. The screenshot shows the free version which only loads four objects. The Unlimited version offers all objects for inclusion.
The Import New option can be used if the database does not show in the list and you wish to load it from source
The final screen contains a Source Control Path which should point to a folder within your source control project.
Select Export or Import… in this example we are going to Export.
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.