Make a Database Schema Change

Issues represents a collaboration between developer and DBA (like creating a database or altering a schema). It's similar to the issue concept in other issue management tools.

Issue drives the database change workflow covering Database Creation, DDL and DML.

Create an issue#

Go to your project page, choose one or several databases to Edit Schema.

You may use the Schema Editor to visually design the schema.

Alternatively, you can switch to the Raw SQL mode. You can sync the raw SQL from the schema editor or supply your own SQL statements.

Once you finish writing the SQL, click Preview issue.

By default, Bytebase will create a Rollout issue. You can check SQL Review Only to create a review-only issue.

Rollout an issue#

If there's a SQL review warning, you may need to fix it first.

An issue may also require one or multiple manual approvals. Once all approvals are granted, the issue can be rolled out.

Issue lifecycle#

Here's a graph demonstrating the issue lifecycle.

Bytebase supports 2 change workflow, UI and GitOps. Check Database Change Workflow for further details.