Physical Data Modeling with System Architect work around solution for easy handling

100 % third party component / exe free solution. so, all you need is SSMS or any other SQL Editor.
I bet most of the physical data modelers would have come across enough happy moments with System Architect tool (SA).

so, when we build / convert physical data model, we would come across few challenges
1. Names of Tables, Columns, Relationship would not be in proper format
2. Constraints
3. Indexes
4. Maintaining Associative Relationships from LDM to PDM.

so, the solution is instead of modifying names, relationships & constraints in SA, we could do it simply in SQL Editor and reverse engineer back to SA.

here are few steps would involve to make this happen.

• open LDM
• Click Dictionary --> Create Data Model --> Physical Data Model
• Open PDM
• Click Tools-->DB Schema Generation
• Choose SQL Server any version availabe as Target db --> Next
• Give local path for storing SQL DDL.. etc and finish the wizard to generate DDL
• open DDL in any Editor, modify table names, column names as per the requirement
• check constraints for all entities
• Execute the SQL in SSMS to ensure the script is bug free.
• Reverse Engineer back in SA in order to replace PDM.