Problems with Testing Database
As I've been working iteratively during the testing process, I've come across several problems that I've experienced, mostly that deals with how I work. The primary issue you have to be concerned with, if you follow my "using a SQL 2005 Express database for testing", is making changes to it. You actually have to maintain two separate databases, unless you use a process to compare the two sources. Because I want to run the application, I didn't do that; plus, the original is currently SQL Server 2000 for the time being, and I didn't think scripting changes could go back to 2000 with full compatibility. So, there are some considerations to keep in mind when doing this.