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

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

aspxgridview - Devexpress grid - header filter does not work if column is initially hidden -

c# - How to execute a particular part of code asynchronously in a class -