A reliable application which allows you to quickly transfer information fields and structures from SQLite to MySQL, via manual configuration or query.
- SqliteToMysql
- Version : 2.0 Release 1 Build 170614
- License :Trial
- OS :Windows All
- Publisher :Withdata Software
SqliteToMysql Description
SqliteToMysql is a simple to use tool that allows you to export data from SQLite straight into MySQL. The application requires that you connect to both database managers, in order to ensure a lossless data transfer and allow the migration of entire tables.
The software ensures a quick and easy data migration process. SqliteToMysql allows you to manually configure the source for the transfer, namely the information from a single table or multiple such structures. Alternatively, you can define the input data, by creating a SQL query.
The application allows you to even configure and control the entire migration process via query., an option dedicated to users with advanced SQL knowledge. Otherwise, you can use the several wizard functions which offer support for each step of the process.
The data transfer requires connection to both database managers, defining the source, the destination and the type of migration.
You can select the source and destination databases from the list of available locations, then configure the rows. The fields you wish transferred need to be selected, as opposed to those you wish to ignore.
In case of single table transfer, you can even create a new location in the selected database, in case the destination table that you desire does not exist. Moreover, you can select the type of transfer, namely data replacement, updating or appending.
Once these settings are made, you can either start the process or save the session and run it at a later time.
Moreover, you can use the command line in order to run the transfer process. All you need to do is save the session, create a batch (.BAT) file, then run it in command line.
Additionally, SqliteToMysql allows you to schedule tasks, which can automatically be performed at the specified time. You can create a single time task or recurrent transfers between the same databases.
System requirements
- MySQL
Limitations in the unregistered version
- 30 days trial
- Nag screen