Here is the requirement:
Assistance is needed with data analysis, visualization, transformation, and mapping for migrating a SQL Server source database to a SQL Server target database. Specifically, support is required in mapping tables and columns from the source to the target. The challenge lies in the fact that there are very few direct matches between the tables and columns in the two databases, necessitating data transformations and the visualization of the mappings to the target.
The current setup involves a source database with an Access front-end connected to a SQL Server back-end. The goal is to migrate this to an existing target database, without creating new tables or columns, as the .NET front-end application cannot be modified. This adds complexity, as there won’t always be direct one-to-one matches between the tables and structures of the two databases.