The following items apply to all FogBugz On Site installations:

  • Ensure your hardware configuration meets the recommended specs outlined in the On Site System Requirements
  • Download the FogBugz On Site ISO and ensure it is available at the time of installation. A Fog Creek technician will provide download details when scheduling your installation. The ISO image can be burned to physical media or mounted. ISO image mounting is available in Windows Server 2012 R2 or via separate tooling.
  • Ensure the Web Server (IIS) Role is enabled on the server where FogBugz On Site will be installed. In Windows Server 2012 R2, this can be installed with Add Roles & Features.
  • Ensure .NET 3.5 is installed on the server where FogBugz On Site will be installed. In Windows Server 2012 R2, this can be installed with Add Roles & Features.
  • Ensure the PowerShell execution policy has been set to RemoteSigned or Unrestricted on the server where FogBugz On Site will be installed (Set-ExecutionPolicy RemoteSigned). This is required to run the FogBugz On Site installation PowerShell script and can be reversed once the installation is complete (Get-ExecutionPolicy will return your current policy).
  • Create a Windows Local Administrator account (e.g. fogbugz-onsite) under which the FogBugz On Site application pools will run. Please have the credentials for this account available at the time of installation. If you plan to use Windows authentication for database access in FogBugz On Site, please create a SQL user for this Windows account on your target SQL Server instance and grant this user the dbcreator role. Account permission can be reduced to db_owner on your FogBugz On Site databases once the installation is complete.
  • If you plan to use SQL authentication for database access in FogBugz On Site, please create a SQL authentication account (e.g. fogbugz-onsite) on the target SQL Server instance. This account must be granted the dbcreator role. Account permission can be reduced to db_owner on your FogBugz On Site databases once the installation is complete. Please have the credentials for this account available at the time of installation.

Migrating Existing FogBugz Data

The following items apply if we are migrating data from an existing FogBugz For Your Server installation to your new FogBugz On Site installation.

  • To migrate your existing FogBugz data, a SQL Server backup of your FogBugz database will be required. This backup will be restored to your FogBugz On Site database created during your installation. For the best experience possible, please have this backup available locally on your FogBugz On Site database server at the time of installation. Sufficient permission will be required to restore this backup to your FogBugz On Site database server.
  • Before your scheduled installation date, please send us a bare schema export of your current FogBugz For Your Server database. We require this to prepare a script which will correct any schema drift which may have occurred with your FogBugz For Your Server database over time. This schema export must include index creation. To generate this export from SQL Server Management Studio:
    • Right-click on your FogBugz database and select Tasks > Generate Scripts…
    • Under Choose Objects, select Tables (which will select all Tables) and click the Next > button.
    • Under Set Scripting Options click the Advanced button.
    • Ensure Script Indexes is set to True.
    • Save to a .sql file with Unicode text.
    • Send us this .sql file before your scheduled installation date.

Before your scheduled installation date, please send us your current database schema version. You can query this by running the following SQL statement against your FogBugz database:

 

SELECT ixVersion FROM [Version];