I have an existing SQL database that contains source records.
Unfortunately my source data just changed and I would like to delete the old source and map the new source into the existing database.
The SQL has only 4 tables and 1 wont change at all
The new source has a unified format with 50+ fields, but i will be using only about half of them. Attached is a copy of the unified layout and the rows in blue are the only ones I need for that source. The rest of the fields are NULL.
At this point i want someone to build a new SQL DB based on the unified source I will send instead of modifying the existing one and then importing the new source.