Dynamic Database Migration – OnPrem to Cloud(Azure)

Client had a legacy sql server and there were lot of performance issues. Developed a new data model along with migration of database from on-premise to cloud.

Solution

• Automated the process of loading valid data from files to synapse tables without any manual intervention
• Used dbt to validate business logics accordingly
• Understood client’s legacy data model and reports by reverse engineering to implement the same business logic in synapse to fill the gaps in data model and update the stored procedures in synapse to sync with the latest data model
• Created stored procedures in synapse to output the same legacy report data