Access: Converting your Access Database to Another Format

For instructions on migrating your data from MS Access to SQL Server click here.

For migrating from MS Access to MySQL, read on.

  1. 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.
  2. Backup your existing database. Make a copy of your FogBugz.mdb file.
  3. Convert your Access database. We don't endorse or recommend any single program, but here is a list of conversion utilities on the MySQL site. Choose one of these programs and convert your database to MySQL format.
  4. 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.
  5. Please click here for the details of setting up MySQL to run with FogBugz for Windows.