Learn to move schema change from test to prod.
Basic Project
. Now you can operate within the project.
test
to prod
as follows.
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.
prod
as target database.
test
to prod
.
Basic Project
interface, enter Changelists section on the left-side bar, where you can create a New Changelist.
+
to Add Change.
Change History
as Change source to add our former schema changes to changelist. Or, we can edit Raw SQL to add any schema change to our changelist.