Expert MS Access to SQL Server Express Migration & Front-End Optimization
Budget: $250 – $750 USD
Project Overview
We have an existing Microsoft Access [Year2019/ 365] application currently split into a front-end and back-end. We need to migrate the back-end data to SQL Server Express to improve stability and multi-user performance. The front-end must remain in Access and be optimized to work efficiently with the new SQL back-end.
Key Tasks & Responsibilities
Database Migration: Upsize all tables from the Access .accdb/.mdb file to a SQL Server Express instance.
Data Integrity: Ensure all primary keys, foreign keys, and relationships are correctly mapped and enforced in SQL Server.
Table Linking: Use ODBC to link the Access front-end to the new SQL Server tables.
Query Optimization: Identify and convert "heavy" Access queries into SQL Server Views or Stored Procedures (Pass-Through queries) to ensure the system doesn't lag.
VBA Troubleshooting: Fix any existing VBA code that relies on DAO/ADO logic that might break after the migration.
Security: Configure basic SQL Server permissions for 4 users.
Technical Requirements
Deep expertise in T-SQL and MS Access.
Proven experience with ODBC connectivity and DSN-less connections.
Strong understanding of linked table management and performance tuning.
Ability to work via Remote Desktop or provide a migration script.
Project Scope
Total Tables: [70 tables]
Total Records: [Largest table has 18 500 rows]
Number of Users: 4
We have an existing Microsoft Access [Year2019/ 365] application currently split into a front-end and back-end. We need to migrate the back-end data to SQL Server Express to improve stability and multi-user performance. The front-end must remain in Access and be optimized to work efficiently with the new SQL back-end.
Key Tasks & Responsibilities
Database Migration: Upsize all tables from the Access .accdb/.mdb file to a SQL Server Express instance.
Data Integrity: Ensure all primary keys, foreign keys, and relationships are correctly mapped and enforced in SQL Server.
Table Linking: Use ODBC to link the Access front-end to the new SQL Server tables.
Query Optimization: Identify and convert "heavy" Access queries into SQL Server Views or Stored Procedures (Pass-Through queries) to ensure the system doesn't lag.
VBA Troubleshooting: Fix any existing VBA code that relies on DAO/ADO logic that might break after the migration.
Security: Configure basic SQL Server permissions for 4 users.
Technical Requirements
Deep expertise in T-SQL and MS Access.
Proven experience with ODBC connectivity and DSN-less connections.
Strong understanding of linked table management and performance tuning.
Ability to work via Remote Desktop or provide a migration script.
Project Scope
Total Tables: [70 tables]
Total Records: [Largest table has 18 500 rows]
Number of Users: 4