Changes between Version 14 and Version 15 of SqLiteToMySql

Timestamp:

Jul 14, 2011, 4:44:24 PM (13 years ago)

Author:

Pokesoft

Comment:

Added a link (shamelessly) to my summerised migration steps

SqLiteToMySql

@@ -116 +116 @@
 
 Also, look at ticket:6986 to significantly improve Trac performance with MySQL.
+
+----
+
+This page helped me a lot with my migration. I have a summerised procedure here: http://www.pokesoft.net/blog/?p=473
+
+I've also modified the Python {{{cleansql}}} script, which will now take in both the mysql table structure SQL and the SQLite SQL. It will remove the {{{PRAGMA}}} statement and convert {{{CAST(p.value AS int)}}} to {{{CAST(p.value AS signed)}}}. It will also try to fix the backslash escaped quotes(!). Not the best script but it worked for me :)