Fog Creek Software
Discussion Board




Kudos, and question about migrating...

Hi there,

I just installed my copy of FogBUGZ, and I have to give you all my kudos.  I had a problem post-install that was neatly covered by "What Went Wrong?" (the default database was wrong in the ODBC DSN); I fixed it, and it worked fine.

However, I do have a question.  Eventually, the server FogBUGZ is on now (Win2k running IIS and SQL Server 2000) will be downed, and we'll have a server farm (distinct machines for web serving and SQL Server).  How hard will it be to migrate my current database to a new FogBUGZ installation so I don't lose my bug data?

Jim Causey
Tuesday, March 05, 2002

it will be extremely easy, nay, downright trivial :)

The hardest part will be if the final URL for FogBUGZ changes. To innoculate yourself against that, I suggest reserving a domain name for fogbugz such as fogbugz.mycompany.com, and setting up your current IIS server to respond to that. Then when you migrate you can make one change in DNS and nobody will even know you've moved the system. In fact you can move without interruption by running IIS on two machines, both pointing at the same database, while the DNS change kicks in.

Joel Spolsky
Tuesday, March 05, 2002

Thanks for the quick response, Joel.  I have a further question.

I went ahead and did a FogBUGZ install on my dev server, so I have a URL like http://jimsdev.dept.company/FogBUGZ/; when I migrate, if the IIS server responds to http://fogbugz.dept.company instead, how much will I have to change?  Or can I make those changes now ahead of time?

Jim Causey
Thursday, March 07, 2002

I suggest setting it up now with the permanent name you expect to use and then move that name in DNS.

Joel Spolsky
Wednesday, March 13, 2002

*  Recent Topics

*  Fog Creek Home