Viobo MSSQL to Access Data Migrator Pro Portable is a lightweight, zero-installation utility designed to export and convert databases from Microsoft SQL Server (MSSQL) into Microsoft Access (.mdb or .accdb) formats. Developed by Viobo Software, this portable version runs directly from a USB drive or local folder without requiring an installation process or administrative rights on the host machine.
Below is a comprehensive guide to understanding and using this utility. Key Features
Zero Installation: Runs as a single executable file, leaving no trace in the Windows Registry.
No Database Admin Experience Required: Uses a simplified visual workflow rather than complex command-line scripts.
Tree-Structure Navigation: Displays both source and target databases in a clear side-by-side hierarchical tree view.
Drag-and-Drop Mapping: Allows tables, schemas, and fields to be mapped from MSSQL to Access simply by dragging them across panels.
Native Provider Support: Operates directly via OLEDB or ODBC database providers, meaning you do not need full official client management tools installed on the migration machine.
Data Integrity Mechanisms: Includes a built-in Task-Queue and Multithread-Management system to ensure mass data transfers maintain integrity without dropping records. Step-by-Step Operation Guide 1. Launching the Tool
Download the portable archive and extract the folder to your preferred location (or a portable storage device).
Double-click the Viobo_MSSQL2Access.exe file to open the software instantly. 2. Connecting the Source (MSSQL) Click on Source Connection or the source database icon.
Choose your connection type (e.g., standard SQL Server authentication or Windows Authentication).
Input your server address, username, password, and select the specific MSSQL database you wish to extract data from.
The tool will fetch the structure and populate the left panel as a tree layout. 3. Connecting the Target (MS Access)
Click on Target Connection or the destination database icon.
Select whether you are migrating into an existing Access file or creating a clean, new file.
Browse to the path of your .mdb or .accdb file and connect. The structure will map to the right panel. 4. Mapping and Data Transformation
Expand the source tree to view individual tables, views, or schemas.
Select the objects you wish to migrate. You can choose to move entire schemas or drill down to select individual tables.
Use the drag-and-drop interface to align the tables to the target Access database. 5. Executing the Migration
Review the migration parameters (such as managing character sets or handling basic data-type conversions). Add the configurations to the Task Queue.
Click Start / Migrate to initiate the multi-threaded transfer process.
Monitor the real-time progress bar; the tool will log any structural errors or skipped rows. Important Alternatives to Consider
Because the Viobo tool line has a minimal updates schedule, it may struggle with modern security protocols or complex SQL Server configurations (such as cloud-hosted Azure instances). Depending on your setup, consider these alternatives:
Microsoft Access Built-In Tools: You can natively import data directly inside MS Access using the “External Data” tab and setting up an ODBC connection to your SQL Server.
Microsoft Data Migration Assistant (DMA): The official, free utility from Microsoft for assessment and database movement.
Third-Party Migrators: Tools like the SysTools Access to SQL Migrator are highly reliable if you need to perform the migration in reverse (Access to MSSQL).
If you are running into specific issues with your migration project, let me know:
The exact versions of SQL Server and MS Access you are using The size of the database you want to migrate
Any specific error messages or data-type mismities you have encountered
Leave a Reply