Migrate database engine from MySQL to SQLite: Difference between revisions

Migrate database engine from MySQL to SQLite (edit)

613 bytes removed , 9 November 2019

m

no edit summary

15,050

edits

@@ Line 3: / Line 3: @@
 == Steps of migration database engine from MySQL to SQLite ==
-# Migrate database data from MySQL to SQLite using the SQLite management software
+# Migrate database data from MySQL to SQLite using the [[SQLite management software]]
 # Modify the scripts of database access
 # Testing the scripts
@@ Line 24: / Line 24: @@
 * Other functions are not supported such as: SET
-== SQLite management software ==
-Comparison of SQLite management softwares
-[https://sqlitebrowser.org/ DB Browser for SQLite] v. 3.11.2
-* Import: (1) database from SQL file (2) table from CSV file
-* Export: (1) database to SQL file (2) table(s) as CSV file (3) table(s) as JSON file
-* Export the query result: ok. Steps (1) execute SQL (2) click "Save the results" as CSV file
-''$'' [https://www.navicat.com/cht/products/navicat-premium Navicat Premium]
-* Import: (1) database from SQL file (2) table from CSV/Excel file
-* Export: (1) database to SQL file (2) table as CSV/Excel file
-* Export the query result: ok
 == References ==