MSSQL to MySQL Database Conversion
Question asked by Mark McDonald - March 7, 2017 at 2:48 PM
We're running v10.4 of SmarterTrack and while we'd like to upgrade, it's the last application supported by a legacy MSSQL installation that we're trying to get rid of.  What is the migration path to move a database from MSSQL to MySQL?  We can run the import Wizard on MySQL, however it sometimes classifies fields as the wrong data type, which we're concerned about.
Is there a script we can run afterwards to convert all fields to the proper data type and reindex the database?  We asked about this a while back and was told it's just not possible, so it's either on to another product for us or we get this migration done and continue using SmarterTrack.

Reply to Thread