Move old install to new install

SOLVED

We have a Sage CRM install that dates back to before version 7.1.  I am not sure of the original install date.  It has been upgraded along the way and is currently on version CRM2019.  Unfortunately, the upgrades do not give an old install 100% of the same functionality as a new install. 

The main difference is how a record's primary key is handled.    

In addition since this install is so old, it appears that there are fields that exist in SQL and not in Sage CRM.  Beginning with CRM2019, CRM began showing these fields with brackets [ ] around them in the Sage CRM interface after any change was made to any field or screen. When this occurs, it drops all the main tabs (ie MyCRM, TeamCRM, Reports, etc.). They no longer display.  The only tabs that do display are tabs that have [brackets] around them.  Therefore, the system becomes unusable.  If we do an IIS reset, it removes all the bracket fields and the system operates fine.  However, they come back the next time we make any field changes.

Based on the above, we want to start from scratch with a new install and bring the records over from the old install.  What is the best way to accomplish this?

I am wondering if there are any guideline to follow?  Are there any tools to assist in doing this?

Below are some of the things I think we will need to consider however I am sure there are more.

We will need to keep the primary keys intact so that we do not loose the record relationships (or figure out a way to remap them).

Meta data tables...do I bring these over as they existed in the original install?

If we bring the meta data table data over as it existed in the original install, will I be able to add fields that don't currently exist in the new install directly in SQL and then marry them up with a metadata refresh?

What else am I not thinking about that we will need to consider?

Any assistance would be greatly appreciated.  Thank you!