This is a software tool that helps in data migration from MS SQLserver database to MS Access.
MsSqlToAccess is a software tool to let you export data from SQL Server to Access easily and quickly. This is not a tool for everyone. The database administrators and developers working on these databases are the audience. The whole transfer process is automated through the wizard based interface. The simplicity and ease of use of the interface is the strength of the program. It can be set up so easily! You choose a schema and a destination filename. Since the file structure is different in Access 2007 and beyond, you have to make a choice if you want MDB or ACCDB file type for the destination file. Once the schema is chosen, you get a display of all the tables with additional information that gets filled in when transfers are completed.
All the tables are displayed with checkboxes. You select the ones you want and get the export initiated. As each table is transferred, you get the display updated by destination table name, how many rows of data it had and a “done” message. The lower part of the display area shows a progress bar and on a separate tab, logs of the process. Tthe logs will prove to be useful when any debug is to be done, something having gone wrong during a transfer. Multiple tables could be transferred at a time. Other ways the export can be done is through query, through the command line and scheduling the transfers. Session parameters can be saved and reused. Unicode support makes it possible to use with any kind of language based data.