How to keep the table names, generated by smartmapper "Sync ER model with DB" option, constant across environments say dev, staging, production etc.?
Article ID: KB0086606
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for SmartMapper | - |
| Not Applicable | - |
Description
Resolution:
This can be achieved by following the below approach
1. Once the ER model design is finalized in designer, use the "Sync ER model with DB" button and then use "Generate SQL" option, not "Perform Sync" option to generate the SQL.
2. Once the SQL script is generated, the same script can be run from DB Client tool and commit, to Sync the ER model with DB.
3. The same script can be used across environments to keep the tables names constant across environments.
The same approach can be followed to incorporated any change to the ER model as well.
Note: Users are cautioned not to change any thing in the SQL script generated by "Generate SQL" option.
KEYWORDS: ER MODEL CONSTANT ACROSS ENVIRONMENTS SYNC WITH DB
This can be achieved by following the below approach
1. Once the ER model design is finalized in designer, use the "Sync ER model with DB" button and then use "Generate SQL" option, not "Perform Sync" option to generate the SQL.
2. Once the SQL script is generated, the same script can be run from DB Client tool and commit, to Sync the ER model with DB.
3. The same script can be used across environments to keep the tables names constant across environments.
The same approach can be followed to incorporated any change to the ER model as well.
Note: Users are cautioned not to change any thing in the SQL script generated by "Generate SQL" option.
KEYWORDS: ER MODEL CONSTANT ACROSS ENVIRONMENTS SYNC WITH DB
Issue/Introduction
How to keep the table names, generated by smartmapper "Sync ER model with DB" option, constant across environments say dev, staging, production etc.?
Feedback
Yes
No
Powered by
