This question came up the other day from Craig P. and I thought it was such a good one I wanted to blog about it. I think many of us take it for granted that upgrading from Access to SQL is a natural progression but we sometimes forget the “why” of it all. the bottom line is that sometimes the answer is to upgrade but sometimes the answer is to keep using Access. Making informed decisions is important and being able to convince management plays a critical role to your success. So with that I present two articles:
1) Microsoft Access or SQL Server 2005: What’s Right in Your Organization?
2) And, to help compare SQL 2005 vs SQL 2008, “SQL 2005 vs. SQL 2008 Part 1”
Yes, you have to register at that last site unless, of course, you use something like BugMeNot.com: http://www.bugmenot.com/