asp.net - Developing with SQL Server 2005 and deploying to SQL Server 2000 -
i'm developing web application using sql server 2005, asp.net mvc, asp.net sql membership provider (for authentication , authorisation), , linq sql. works great , running planned in development environment.
however, production environment has sql server 2000 installation, , unable obtain copy of sql server 2000 use in development.
upon deploying web application the production environment, options have migrating database (schema + data) 2005 2000?
you should make sure database compatibility in development system set sql server 2000, , consider using tool such redgate toolbelt scripting out schema , data deployment.
Comments
Post a Comment