How risky is development against SQL Server 2008 with production on SQL Server 2005

My dev enviro开发者_JS百科nment 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?

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.

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).

Not a complete answer, but make sure not to use the Date type in development. Use DateTime as that's supported in both versions.