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