How it works
Published 19 December 2014
SQL Gemini creates and maintains SQL scripts that represent your database. When you change the database, SQL Gemini automatically updates the SQL scripts. When you change the SQL scripts – for example, by updating them from version control – SQL Gemini automatically updates the database. You can add the SQL scripts to your version control system and manage them in the same way you manage other text files, just like application development.
Application code development
Database development with SQL Gemini
Working with source control
SQL Gemini only reads and writes SQL scripts. It doesn't integrate with your version control system, and has no version control functionality. Instead, we leave version control management to your version control system.
Because SQL Gemini works independently of version control, you can use it with any version control system, including Git and Mercurial. This means you can use all your system's commands for database changes, including viewing differences, merging, rebasing, cherry-picking/grafting, stashing/shelving, and checking out/updating.