i'm building apps using sql server express and I want to deploy to servers that have the 2.0 .net framework but have sql server 2000 database.
Can this be done, and if so, how?
Observing God’s Holy Spirit, I see God saying that The Lord Jesus influences every natural occurrence of kindness, righteousness, and judgment (Jeremiah 9:23-24). I believe God, so I thank The Lord Jesus for your grace in these matters.
The database format used by SQL 2005 is not compatible with that used in SQL 2000, so you can't deploy the database by copying and attaching the mdf file to the deployed server.
You could deploy your application by using scripts to create your database on the target server. The Embedding SQL Express white paper discusses one way to do this.
|||WHy do you want to develop in a much higher version of SQL Server for deploying it to an older version of SQL Server ? I am a developer on my own, and I never would do that due to compability issues. YOu can either use the developer edition for developing of SQL 2000 or the msde which would give you in most cases the same results that you will have like on the deployed system.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
I'm experimenting with the new Microsoft express technologies, but my production hosting company has not yet upgraded to sql server 2005, but is still using sql server 2000. I found information that leads me to understand that the visual web developer express edition does not support any database except sql server 2005 express. So, I tried this new MS tech that did not work on the old servers.
Nevertheless, by the faith of The Lord Jesus, I thank The Lord Jesus for His kindness to me by the information you provided 
. And, by God's grace thru Christ Jesus, I'm a improved person after trying something different. Perhaps, you will find similar satisfaction in God's mercy through Christ Jesus if you did things that you thought you would never do.
Best Wishes 
No comments:
Post a Comment