SQL Server: Importing data from FogBugz On Demand or trial into SQL Server

2009-10-13T21:24:26Z

How do I import data from my Fogbugz On Demand trial to SQL Server 2005 and 2008?

NB: FogBugz 7 does run on SQL Server 2000, but with limited functionality. We recommend 2005 or above.

Answer by FogBugz KB for SQL Server: Importing data from FogBugz On Demand or trial into SQL Server

2009-10-13T21:27:35Z

Step 1

Run FogBugz Setup. Choose SQL Server as the database option. When Setup has finished, it launches a web page and asks you to install licenses. Don't install the licenses yet - it's okay if you already did, but you just don't need to. Just minimize this browser, we'll come back to it later.

Don't install licenses yet! (it's ok if you already did)

Step 2

In another browser window, log into your FogBugz On Demand account as a Site Administrator. Click Admin at the top right, then "Your On Demand Account", and click the download link for "SQL Server 2005". FogBugz will warn you that during the database copy, the site will be down. Make sure nobody needs to use FogBugz and then click "Begin Copy"

The download may take many hours if you have a large database. If it takes too long or fails, please contact us for other options.

After the copy is complete, click the Download button that appears to download your MDF data file (it will be named something like fogbugz72040459_copy.MDF), and save it to the folder that MS SQL Server likes to keep data files, which is normally:

C:\Program Files\Microsoft SQL Server\MSSQL\Data

Make sure this file is not read-only and that the user SQL Server runs as has full control for it and the directory it is in.

At this point, your FogBugz On Demand account is still locked for the download. On the page you downloaded from, either enter a URL for a new site to link to, or click the link next to "Go back" to reactivate the site if you need to keep using it.

Step 3

Run SQL Server Management Studio and connect to your database server. Drill down to the empty database named FogBugz that was created by Setup. Select it and press the Delete key to delete it.

Step 4

Right click the Databases item and choose Attach...

In the dialog which appears, click the "Add..." button and select the MDF file you just downloaded. The dialog will now look like this. Click the second entry in the bottom pane, which has File Type "Log" and click the Remove button:

If the Data row has an incorrect path for "Current File Path", change it to the path of the mdf where you just moved it.

In the top pane, click on the Owner field, then click again to bring up the menu. Select the same user you told setup to run FogBugz as. If you told Setup to use Windows/Mixed Mode authentication to connect to the database, this user is the same one you see for Anonymous Authentication in the FogBugz virtual directory. If you told Setup to connect to the database using a SQL Server login (name and password), then specify that login here. Click OK.

Step 5

Bring up FogBugz in your web browser and refresh the page. If at this point you get an error message, please re-read the above steps and verify that you didn't do something ever so slightly differently.

Install your licenses
Set your options in Admin -> Site Configuration
- The FogBugz Maintenance URL
- Notification URL
- Your outgoing SMTP server information

Users will lot in with the same credentials from your hosted account. Presto magicko, you should see all the data you created on our server like so many eggs in a basket!

Step 6

Remove the On Demand only cases@ mailbox:

DELETE FROM Mailbox WHERE sEmail like 'cases@%.fogbugz.com';

Step 7

Re-install your plugins per this question.

SQL Server: Importing data from FogBugz On Demand or trial into SQL Server - FogBugz Knowledge Exchange

SQL Server: Importing data from FogBugz On Demand or trial into SQL Server

Answer by FogBugz KB for SQL Server: Importing data from FogBugz On Demand or trial into SQL Server