B4J Code Snippet Emigrate Mysql to Sqlite DB

Fellows.

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


1651025636245.png


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

1651025908601.png


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
 

Attachments

  • situ.zip
    4 KB · Views: 43

Magma

Well-Known Member
Licensed User
Longtime User
Didn't tried but seems OK... may be need to add some more types... but i think is very good, thanks for sharing !!!
 

Magma

Well-Known Member
Licensed User
Longtime User
Type of fields... double, bigint... from the other hand sqllite not care a lot about them
 

busmatic

Active Member
Licensed User
Each column in an SQLite 3 database is assigned one of the following type affinities:
  • TEXT.
  • NUMERIC.
  • INTEGER.
  • REAL.
  • BLO

  • The conversion was done according to the field types supported by sqlite3.
Thanks for asking.
 
Last edited:
Top