Sample Project
, there are two databases hr_test
on Test
environment and hr_prod
on Prod
environment. Let’s create another one on Prod
.
hr_prod_2
Prod
Prod Sample Instance
bbsample
hr_prod_2
will be ready when the issue is Done
.
hr_prod
as the source schema, and click Next.
Done
, the schema synchronization is completed.
hr_test
and click Edit Schema. With the help of Schema Editor, add a new column email
as follows and click Preview issue:
email
text
Empty string
checked
Done
, the new column email
is added.
hr_test
as the source schema and click Next.
hr_prod
and hr_prod_2
as the target databases. Schema differences are calculated and the suggested DDL statements are generated. Click Preview issue.
Done
, and email
is added.
Sample Project
, click Sync Schema and select hr_test
as the source schema. When you choose the schema version, you will see the following prompt. That’s because we haven’t assigned the enterprise license to database instances.
hr_test
as the target, and click Select.
Done
, the schema rolls back to the previous version.