This guide details the steps for using the 2SQL MSO Inspector for scanning of Access Databases or Excel Files, reporting of metadata and properties that assist in Business Intelligence initiatives and in measuring overall migration and conversion complexity.
This document explains the features and functionality of the 2SQL Toolkit – software utilities and documented processes which support the process of arriving at a fully and completely converted Microsoft Access database to SQL Server.
The User Guide fully describes all of the steps for using 2SQL from setup and installation; to scanning a database for conversion issues; to processing the database to apply its automated conversions; and finally to the Manual Cleanup phase to complete the conversion and migration process.
Analyse the company’s Microsoft Access and Excel application population across its network drives. Obtain comprehensive metadata details of the Access/Excel footprint. Determine candidate Access applications/databases for conversion to SQL Server