How to Move Schema Change from Test to Prod

Learn to move schema change from test to prod.

We’re demonstrating this process using our sample demo data in the Basic Project. Select Project on the upper-left where you choose Basic Project. Now you can operate within the project.

You have three options to move schema change from test to prod as follows.

Option 1: Streamlined rollout

Go to Database -> Databases section on the left-side bar. Select both databases to Edit Schema, where you type in raw SQL code in the code block and click Create. Checks will automatically run and then you can Approve the change and Rollout.

Option 2: Schema Synchronization

Also within Database -> Databases section on the left-side bar in Basic Project interface, select only test database to Edit Schema. Create, Approve and Rollout like we did to the two databases in Option 1.

Then enter Sync Schema on the left-side bar. Select test in Database to refer to, and choose a Schema version. Click Next.

Select prod as target database.

You can see how Bytebase shows the diff between the test database (source) and the prod database (target). Preview issue to deploy the difference

Create this issue, approve and deploy as we did before.

Thus we have successfully propagate the change from test to prod.

Related docs

• Streamlined Rollout
• Schema Synchronization