Monday, March 12, 2012

VS 2005 with Server 2000 and SQL 2000

I am getting stuck developing a web app for deployment on an MS 2000 server with SQL Server 2000. I want to use VS 2005 with .NET 2 to do my development. Can anyone point me to resources that deal with this or have any specific "gotchas" I need to watch out for?

TIA

Daniel

The only thing I can think of offhand is that if you don't have access to SQL Server 2000 to develop against, pick up a copy of SQL Server 2000 Developer Edition for your development machine. If you develop against, say SQL Server 2005 (Standard or Express) for a SQL 2000 implementation, that could be a potential source of trouble.

I maintain some sites that still use 2000 (we are slowly migrating them over to 2005) and it's not that different. The basic ADO.NET stuff works the same. I'd say don't sweat it.


One thing to keep in mind: SQL2005/Express database files (both .mdf and ldf)?can't?used?in?previous versions?SQL?Server,?as?there?are?lots?of?changes?in?database?system?schema?in?SQL2005.

0 comments:

Post a Comment