We offer attended migrations of your existing For Your Server data to FogBugz On Site, typically during our normal business hours (9AM to 5PM Eastern, Monday to Friday). If you’d prefer to migrate your data yourself, great! The following outlines that process, with minimal help from us.

Please note that this document applies to customers already using SQL Server. To import a MySQL database, you’ll need to first convert to SQL Server.

Getting Started

With proper preparation, migrating data to FogBugz On Site can be accomplished with minimal downtime.

  1. Before your scheduled migration date, send us the schema of your FogBugz database. We will generate a SQL script to correct any schema drift that may not be automatically handled during the migration.
  2. Make sure a SQL Server backup of the FogBugz For Your Server database is available locally on the FogBugz On Site database server. For reduced downtime, we recommend moving the FYS database to your new server before the migration to On Site.
  3. Install FogBugz On Site. For reduced downtime, do this ahead of your migration date.

Migrating the Data

  1. Stop IIS on both the FogBugz On Site and For Your Server web servers
  2. Restore the FogBugz For Your Server SQL Server backup over the top of the FogBugz On Site trialN database (or simply rename the databases if they are on the same server already).
  3. Ensure the FogBugz On Site database user is mapped as db_owner on the new trialN database.
  4. Disable active mailboxes. This gives you an opportunity to confirm the migrated data before pulling in new cases from any active mailboxes:
    UPDATE Mailbox SET fEnabled = 0 WHERE fDeleted = 0;
  5. If this is a test instance, we recommend sanitizing the database to avoid interactions with your production instance.
  6. Start IIS on the FogBugz On Site web server, and allow the database to be automatically upgraded.
  7. Run the SQL script we provided against the trialN database to correct any schema errors.
  8. Verify <your FogBugz URL>/?pg=pgSchemaCheck has no errors.
  9. Start ES backfills by navigating to <your FogBugz URL>/f/debug/es from the FogBugz web server (you’ll get 403s from external machines).  You may see an alert that says “Alias not found”.  If that’s the case, click the button below it that says “Create ES Alias”.
  10. Click the “Start Indexer Backfill” button for each document type (bug, wikipage, and discusstopic).
  11. Update the sURLEmailPrefix (if you are changing URLs):
    SELECT * FROM Setting WHERE sKey LIKE '%sURLPrefixEmail%';
    UPDATE Setting SET sValue = '<new URL including protocol>' WHERE sKey LIKE '%sURLPrefixEmail%';
  12. Disable the Kiln plugin:
    UPDATE Plugin SET fEnabled=0 WHERE sPluginId LIKE '%kiln%';
  13. Ensure there are no admin notifications under the Gear Menu
  14. Once you are satisfied with the migrated data, re-enable mailboxes as necessary (Gear Menu > Mailboxes)

Next Steps

Once your data is migrated to FogBugz On Site, you may want to:

If you have any questions or would like assistance with this process, please don’t hesitate to contact us. We’re happy to help!