Access to SQL Server Migration
Budget: $10 – $30 USD
I have a compact Microsoft Access database containing fewer than ten tables that I need moved cleanly into SQL Server. Along with moving the rows themselves, I must keep every primary-key and foreign-key relationship intact so the data model behaves exactly the same once it lands in SQL Server.
You are free to use SQL Server Migration Assistant, SSMS scripts, or your own ETL workflow—as long as the end result is a set of SQL Server tables whose structure and links mirror what I have in Access.
Acceptance criteria
• All tables (1–10 in total) exist in SQL Server with matching column names and data types suited to that platform.
• Every existing PK/FK constraint in Access is recreated and validated on the SQL Server side.
• Row counts between source and target match for each table.
Please include a brief outline of your approach and an estimated turnaround time when you reply.
You are free to use SQL Server Migration Assistant, SSMS scripts, or your own ETL workflow—as long as the end result is a set of SQL Server tables whose structure and links mirror what I have in Access.
Acceptance criteria
• All tables (1–10 in total) exist in SQL Server with matching column names and data types suited to that platform.
• Every existing PK/FK constraint in Access is recreated and validated on the SQL Server side.
• Row counts between source and target match for each table.
Please include a brief outline of your approach and an estimated turnaround time when you reply.