Editor's review
MSSQL to Access is a tool to Convert, Migrate data from / to MS SQL to Access or from MS Access to MSSQL. You can convert multiple tables in one go from MSSQL to Access or from MS Access to MS SQL Server database.
Features: MSSQL to Access is a database conversion tool. It helps conversion/migration between MS SQL server and MS Access databases. It gives you batch operation and you can convert multiple tables in a single operation. At conversion time it is possible to map source table columns to destination table columns easily while you are able to filter rows by WHERE conditions. The program is wizard based. You are able to create SQL dump files. Detailed settings of a session can be saved and you could use them for repeat sessions that have similar situations.
The application has a built in scheduler to get the conversion sessions executed automatically. You can now plan sessions and set the date & time to get the conversions done without have to baby-sit them. MSSQL to Access Loader will automatically execute your session in the background and record the actions in a specified log file. The log file will tell you exactly what happened during the conversion/migration. All such sessions can be stored in a repository and there is a easy to use interface available for managing the repository. Back-up and restores are managed from this interface, for example. You can select/deselect columns when transferring data. You could also change the destination data types easily. Automatic checks of the data types are also possible.
Overall: Quite a neat solution for data migration in a batch and in easy sessions.
User comments