My dev environment has SQL Server 2008 installed. I have an asp.net 1.1 site in production using SQL Server 2005. I'd rather not install SQL Server 2005 on my development environment. How risky would this be? What kinds of things might cause problems?
3 Answers
5
votes
It seems worth looking at this page:
http://msdn.microsoft.com/en-us/library/bb510680.aspx
which describes compatibility levels which can be set against a DB.
0
votes
Considering you're using ASP.NET 1.1, I think that's more your risky part then anything else. If you have a proper ORM layer, you need not worry about the DB version at all.
If you don't have a proper ORM layer, consider changing to using one (but most modern ORM's have come into major usage after ASP.NET 1.1 and do not support anything before 2.0, so you'll have to upgrade sometime, I'm afraid).
