Transfer fields, tables or entire databsaes from SQLite files to Microsoft SQL Server using this speedy application with approachable options.
- SqliteToMsSql
- Version : 2.0 Release 1 Build 170614
- License :Trial
- OS :Windows All
- Publisher :Withdata Software
SqliteToMsSql Description
SqliteToMsSql is an easy to use application designed to help you convert and transfer information from SQLite database format to Microsoft SQL Server. The software is user-friendly, features a graphic interface and offers you a multitude of options regarding data transfer methods.
Export single table configuration
SqliteToMsSql allows you to export a single table, multiple tables or create a query in order to define the source for the export. You may manually configure and modify the parameters or use the wizard functions, that can guide you through every step of the process. Additionally, the software supports being assigned tasks via command line or query.
When transferring information from one single table, the software allows you to quickly set a few options in order to facilitate the correct data migration. Thus, you need to connect to both database managers, SQLite and MS SQL Server, then select the table you wish to transfer from the Source area.
The software creates a preview and allows you to manually select the rows. Moreover, you may select the destination table, from the SQL Server schema and the transfer method: replace, append or update. Additionally, you may create and configure a new table in the source file, then migrate it to the destination schema.
Multi-table migration and transfer via query
SqliteToMsSql allows you to migrate a batch of tables at the same time, by selecting the desired schemas from the SQLite file. You can select the rows you wish to process or the ones you wish to skip, by mapping the fields in each table.
The log tab at the bottom of the window can indicate the progress of the transfer and each table is marked as “Succeeded” or “Failed” in the preview area. Additionally, you may configure the source for the transfer using the “Import From Query” option.
Task automation and scheduling
Each work session is defined by the source data, the destination and the transfer method. You can easily save the sessions and run them again later or schedule them for automatic activation. SqliteToMsSql is capable of running a specific task if you schedule it in advance. Moreover, it can repeat the defined action at the specified time interval.