|
9
|
|
edited Sep 29 2010 at 19:51 |
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 hosted account as a Site Administrator. Click Admin at the top right, then "Your On Demand Account", and click the download link for "SQL
Server 2000". 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"
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:
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, and log on using a name and password from your hosted account. Presto magicko, you should see all the
data you created on our server like so many eggs in a
basket!
Your data is now all there.
Step 6
Re-install your plugins per this question.
|
|
|
|
|
8
|
|
edited Jan 15 2010 at 17:00 |
Update on 9/12/05: There is currently an issue with downloading SQL Server databases from On Demand where occasionally the database you download is missing default values which are needed. So take a moment to check your database: open SQL Server Management Studio, expand FogBugz -> Tables in the left pane, right-click on dbo.Bug and select "Design..." Find fForwarded and fReplied. Click on each and look at the value for "Default Value or Binding" in the pane below. It should be "(0)" as shown here: If it does not, if the default is blank, you will simply need to download the database again and check the one you download in the same way. Step 6 Step 76
|
|
|
|
|
7
|
|
edited Jan 15 2010 at 16:17 |
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 hosted account as a Site Administrator. Click Admin at the top right, then "Your On Demand Account", and click the download link for "SQL
Server 2000". 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"
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.
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:
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
Update on 9/12/05: There is currently an issue with downloading SQL Server databases from On Demand where occasionally the database you download is missing default values which are needed. So take a moment to check your database: open SQL Server Management Studio, expand FogBugz -> Tables in the left pane, right-click on dbo.Bug and select "Design..." Find fForwarded and fReplied. Click on each and look at the value for "Default Value or Binding" in the pane below. It should be "(0)" as shown here:
If it does not, if the default is blank, you will simply need to download the database again and check the one you download in the same way.
Step 6
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, and log on using a name and password from your hosted account. Presto magicko, you should see all the
data you created on our server like so many eggs in a
basket!
Your data is now all there.
Step 7
Re-install your plugins per this question.
|
|
|
|
6
|
|
edited Jan 15 2010 at 16:09 |
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 hosted account as a Site Administrator. Click Admin at the top right, then "Your On Demand Account", and click the download link for "SQL
Server 2000". 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"
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.
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:
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
Update on 9/12/05: There is currently an issue with downloading SQL Server databases from On Demand where occasionally the database you download is missing default values which are needed. So take a moment to check your database: open SQL Server Management Studio, expand FogBugz -> Tables in the left pane, right-click on dbo.Bug and select "Design..." Find fForwarded and fReplied. Click on each and look at the value for "Default Value or Binding" in the pane below. It should be "(0)" as shown here:
If it does not, if the default is blank, you will simply need to download the database again and check the one you download in the same way.
Step 6
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, and log on using a name and password from your hosted account. Presto magicko, you should see all the
data you created on our server like so many eggs in a
basket!
Your data is now all there.
Step 7
Re-install your plugins per this question.
|
|
|
|
|
5
|
|
edited Jan 14 2010 at 19:38 |
In another browser window, log into your hosted account as a Site Administrator. Click Settings Admin at the top right, then "Your On Demand Account", and click the download link for "SQL Server format"2000". On FogBugz will warn you that during the next pagedatabase copy, the site will be down. Make sure nobody needs to use FogBugz and then click "Begin Copy" After the copy is complete, click the Download button that appears to download your MDF data file (it will be named something like fb44135.mdf)fogbugz72040459_copy.MDF), and save it to the folder that MS SQL Server likes to keep data files, which is normally:file is not read-only. 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. Run SQL Enterprise ManagerServer Management Studio and connect to your database server. Drill down to the empty database named All Tasks > Attach DatabaseAttach... In the dialog which appears, click the "..."Add..." button and select the MDF file you just downloaded: Where it says "Specify database owner. The dialog will now look like this. Click the second entry in the bottom pane, which has File Type "- Log" and click the user here needs Remove button: In the top pane, click on the Owner field, then click again to be bring up the menu. Select the same user you told setup to userun 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. Update on 9/12/05: There is currently an issue with downloading SQL Server databases from On Demand where occasionally the database you download is missing default values which are needed. So take a moment to check your database: open Enterprise ManagerSQL Server Management Studio, double click on the Bug table in your expand FogBugz database-> Tables in the left pane, right-click on dbo.Bug and look the select "Design..." Find fForwarded and fReplied. Click on each and fForwarded fields, looking look at the Default column: it must have a value of (0) for "Default Value or Binding" in the pane below. It should be "(0)" as shown here:
|
|
|
|
|
4
|
|
edited Dec 18 2009 at 20:06 |
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 hosted account as a Site Administrator. Click Settings at the top right, then "Your On Demand Account", and click the download link for "SQL
Server format".
On the next page, click Download to download your MDF data file (it will be named something like fb44135.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.
Step 3
Run SQL Enterprise Manager. 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
All Tasks > Attach Database.
In the dialog which appears, click
"..." and select the MDF file you just
downloaded:
Where it says "Specify database owner" - the user here needs to be the same user you told setup to use. 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
Update on 9/12/05: There is currently an issue with downloading SQL Server databases from On Demand where occasionally the database you download is missing default values which are needed. So take a moment to check your database: open Enterprise Manager, double click on the Bug table in your FogBugz database, and look the fReplied and fForwarded fields, looking at the Default column: it must have a value of (0) as shown here:
If it does not, if the default is blank, you will simply need to download the database again and check the one you download in the same way.
Step 6
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, and log on using a name and password from your hosted account. Presto magicko, you should see all the
data you created on our server like so many eggs in a
basket!
Your data is now all there.
Step 7
Re-install your plugins per this question.
|
|
|
|
|
3
|
|
edited Dec 17 2009 at 19:55 |
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 hosted account as a Site Administrator. Click Settings at the top right, then "Your On Demand Account", and click the download link for "SQL
Server format".
On the next page, click Download to download your MDF data file (it will be named something like fb44135.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.
Step 3
Run SQL Enterprise Manager. 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
All Tasks > Attach Database.
In the dialog which appears, click
"..." and select the MDF file you just
downloaded:
Where it says "Specify database owner" - the user here needs to be the same user you told setup to use. 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
Update on 9/12/05: There is currently an issue with downloading SQL Server databases from On Demand where occasionally the database you download is missing default values which are needed. So take a moment to check your database: open Enterprise Manager, double click on the Bug table in your FogBugz database, and look the fReplied and fForwarded fields, looking at the Default column: it must have a value of (0) as shown here:
If it does not, if the default is blank, you will simply need to download the database again and check the one you download in the same way.
Step 6
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, and log on using a name and password from your hosted account. Presto magicko, you should see all the
data you created on our server like so many eggs in a
basket!
Your data is now all there.
Step 7
Re-install your plugins per this question.
|
|
|
|
|
2
|
|
edited Oct 14 2009 at 20:37 |
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 hosted account as a Site Administrator. Click Settings at the top right, then "Your On Demand Account", and click the download link for "SQL
Server format".
On the next page, click Download to download your MDF data file (it will be named something like fb44135.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.
Step 3
Run SQL Enterprise Manager. 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
All Tasks > Attach Database.
In the dialog which appears, click
"..." and select the MDF file you just
downloaded:
Where it says "Specify database owner" - the user here needs to be the same user you told setup to use. 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
Update on 9/12/05: There is currently an issue with downloading SQL Server databases from On Demand where occasionally the database you download is missing default values which are needed. So take a moment to check your database: open Enterprise Manager, double click on the Bug table in your FogBugz database, and look the fReplied and fForwarded fields, looking at the Default column: it must have a value of (0) as shown here:
If it does not, if the default is blank, you will simply need to download the database again and check the one you download in the same way.
Step 6
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, and log on using a name and password from your hosted account. Presto magicko, you should see all the
data you created on our server like so many eggs in a
basket!
Your data is now all there.
|
|
|
|
|
1
|
|
answered Oct 13 2009 at 21:27 FogBugz KB
|
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 hosted account as a Site Administrator. Click Settings at the top right, then "Your On Demand Account", and click the download link for "SQL
Server format".
On the next page, click Download to download your MDF data file (it will be named something like fb44135.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.
Step 3
Run SQL Enterprise Manager. 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
All Tasks > Attach Database.
In the dialog which appears, click
"..." and select the MDF file you just
downloaded:
Where it says "Specify database owner" - the user here needs to be the same user you told setup to use. 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
Update on 9/12/05: There is currently an issue with downloading SQL Server databases from On Demand where occasionally the database you download is missing default values which are needed. So take a moment to check your database: open Enterprise Manager, double click on the Bug table in your FogBugz database, and look the fReplied and fForwarded fields, looking at the Default column: it must have a value of (0) as shown here:
If it does not, if the default is blank, you will simply need to download the database again and check the one you download in the same way.
Step 6
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, and log on using a name and password from your hosted account. Presto magicko, you should see all the
data you created on our server like so many eggs in a
basket!
Your data is now all there.
|
|
|
