One of the hottest things that might scare and a nightmare at least to me when you create a complete project and the customer decide suddenly any of the following cases:
1-Changing (Migrating) the Tables type e.g. From (Excell sheets) to (SQL Server, MySql or Oracle).
2-Transferring the DB address from Location A into location B with completely different address locations.
In both cases above the structure of the data and the map (ER Diagram) didn’t change all we have to do is to consider it when we will refresh the Data On timely based (Weekly or Monthly), With enough guidance by example if possible how can we solve the two cases issues mentioned above?