how to migrate the database

Topics: General
May 29, 2013 at 5:41 PM
We are using BugNET 0.7, and would like to upgrade to BugNET 1.4. The tables name and stored procedures in the database are so different between them. Any ideas about how upgrade the database and/or any tools can do it?

Thanks.
Developer
May 29, 2013 at 5:50 PM
I belive that there is code that will do the upgrade from your version to current.

However
  1. Make a backup of your original site and database
  2. Create a secondary site and database by restoring the originals
  3. Change the web.config connection string in the secondary site to the secondary database
  4. Follow the install/upgrade instructions on the secondary site
  5. Test
  6. Repeat 2 - 5 until it upgrades completed and fully test.
If you are lucky all will go fine, if not post the issues here and see if anyone can help.