Map the existing data contract
- Inventory DAO, ADO, ODBC/OLE DB providers, DSNs and connection strings.
- Identify Access/Jet files, SQL backends, linked tables and local caches.
- Trace saved queries, stored procedures, transactions, locking and generated keys.
- Locate validation/calculation logic split between VB6, queries and database objects.
- Capture representative results, reports and failure behavior.
Stage the transition
| Stabilize | Reproduce current connections and schema before changing technology. |
|---|---|
| Separate access | Consolidate scattered recordset/query behavior behind testable boundaries. |
| Migrate backend | Translate types, indexes and transaction semantics with reconciliation. |
| Modernize application | Replace workflows incrementally after data behavior is proven. |
A successful data copy does not prove query ordering, null behavior, concurrency or business rules are preserved.
Use general VB6 modernization, source analysis, MDB recovery and the database pillar as appropriate.
Provide source/build state, schema, queries, providers, representative data and required continuity.