B4J Code Snippet Emigrate Mysql to Sqlite DB

Fellows.

Here, this is a small app to migrate From DB MySQL to SQLite




Work in B4A / B4J

Its very simple, just checks the additional .jar

Add: MySQL-connector-java-8.0.26.jar

And this one is already included in the core of B4J SQLite-JDBC-3.7.2.jar



Finally, put your data connection

Dim host As String = "LOCAL/IP"
Dim database As String = "Mysql_DB"
Dim usuario As String = "My_user"
Dim password As String = "My_pasword"

And Wait a lithe while, and see the magic emigration
Enjoy

 

[Magma]

Didn't tried but seems OK... may be need to add some more types... but i think is very good, thanks for sharing !!!

 

[Magma]

Type of fields... double, bigint... from the other hand sqllite not care a lot about them