For instructions on migrating your data from MS Access to SQL Server click here.
For migrating from MS Access to MySQL, read on.
- If you are upgrading from a previous version of FogBugz and switching to MySQL, please install the upgraded FogBugz code against the old database, log in once (so FogBugz can do the upgrade) and then proceed to convert your database.
- Backup your existing database. Make a copy of your FogBugz.mdb file.
- Create a shell MySQL database. Follow the instructions here so you end up with just the schema and no data. i.e. make sure you run the truncate.sql script after letting fogbugz build the db.
- Convert your Access database. We don't endorse or recommend any single program, but Best results are obtained by using ESF Database Convert. But you can find a list of (free) conversion utilities on the MySQL site. Choose one of these programs and convert your database to MySQL format.
- Check your new database to make sure the sSignature field in the Licenses table is of type "blob". Some conversion tools will give the sSignature field another type and you will not be able to install licenses! You will simply be prompted to install new licenses over and over again. We have seen this happen using Navicat.
- Please click here for the details of setting up MySQL to run with FogBugz for Windows.
