1. Dbschema Download
2. Dbschema Informix
3. Dbschema Tool
4. Dbschema Pro
5. Dbschema Key

Released:

Schema migration made easy

Project description

dbschema is a tool to run MySQL or PostgreSQL migrationsautomatically. Using a table, it keeps a state of previous migrations toavoid duplicates.

Features:

• Support for MySQL and PostgreSQL
• Optional pre and post-migration queries (for example to updateprivileges)
• Multiple migrations in multiple databases can be processed as one.

Installation

DBSchema is a diagram-oriented database software developed by Wise Coders Solutions. You can use it to simplify complex schemas, generate test data, view information from multiple tables. It has a 64-bit installer that is compatible with most Windows devices with a built-in OpenJDK 12. Dbschema is a tool to run MySQL or PostgreSQL migrations automatically. Using a table, it keeps a state of previous migrations to avoid duplicates. Features: Support for MySQL and PostgreSQL.

Create a config file

Create the file ~/.dbschema.yml and add your databasesconfiguration. See example

Create migrations table

dbschema uses a table called migrations_applied to keep track ofmigrations already applied to avoid duplication. See the schema forMySQL or PostgreSQL.

Migrations folder structure

For each database, you need to have a migration path (setting pathin the migration file).

Within that path you need to create one folder per migration. Thisfolder must contain a file called up.sql with the SQL queries andoptionally a file called down.sql for rollbacks.

Usage

Project details

Release historyRelease notifications | RSS feed

1.4.3

1.4.2

1.4

1.3

1.2.5

1.2.4

1.2.3

1.2.2

1.2.1

1.2

1.1.2

1.1.1

Dbschema Download

1.1

1.0.2

1.0.1

Dbschema Informix

1.0.0

Download files

Dbschema Tool

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Hashes for dbschema-1.4.3-py2.py3-none-any.whl

Dbschema Pro

Hashes for dbschema-1.4.3.tar.gz

Dbschema Key