Sql Server Database Problem
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21997
Printed Date: 30 March 2026 at 4:35am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Sql Server Database Problem
Posted By: Amateur
Subject: Sql Server Database Problem
Date Posted: 22 November 2006 at 1:11pm
|
I have developed an app using sql server 2005 express as the back end. I need to install it on a host who only supports sql server 2000. Changing hosts is not an option unfortunately. Any advice? Can install a swl server database on sql server 2000? |
Replies:
Posted By: michael
Date Posted: 24 November 2006 at 3:42pm
|
Well you are not going to be able to restore a native SQL 2005 database onto the SQL 2000. If you used any of the 2005 features like CLR, Pivot etc you will not be able to convert it out either.
You can either script out the whole DB (including values) or try chaning the Database Compability level to 80, make a backup and then restore it. I never tried to change from 90 to 80 myself... ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: Amateur
Date Posted: 24 November 2006 at 3:46pm
| When you say script out, do you mean create the tables etc on sql server 2000 using SQL? All i have on sql server 2005 are tables and stored procedures and want to put them onto a sql server database. |
Posted By: Amateur
Date Posted: 24 November 2006 at 5:17pm
| O ya, not using any of the 2005 features like clr, pivot etc. |
Posted By: Amateur
Date Posted: 25 November 2006 at 12:42am
|
Or, I was wondering if i bought MS SQL Server 2000 Developer Edition, used this for my backend and uploaded db to server it would work ok, correct? Is it easy to upload SQL Server 2000 db built using this application to hosts server? |
Posted By: iSec
Date Posted: 25 November 2006 at 1:01am
I think so! If your original application uses a mssql 2000 db then it is just fine to upload that db to a server that also uses mssql 2000...
Really, are you willing to buy the developer edition for $3000-5000? I have always wanted to purchase it but it's so damn expensive!
 Thats why I got my copy from school.------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Amateur wrote:Posted By: Amateur
Date Posted: 25 November 2006 at 11:41am
Is it not cheap enough -> http://www.amazon.com/Microsoft-SQL-Server-2000-Developer/dp/B000050AVL - http://www.amazon.com/Microsoft-SQL-Server-2000-Developer/dp/B000050AVL or am i missing something? |
Posted By: michael
Date Posted: 25 November 2006 at 4:10pm
|
Nah Developer is cheap. You don't need to do that though. If you develop a DB on 2005 just make sure you set the Compability level to 80 and you should be fine restoring it on 2000 ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: iSec
Date Posted: 26 November 2006 at 4:56am
|
Oh yes, the developer edition is much cheaper than I thought...See I have always wanted to buy the enterprise version so I could be a mssql hosting provider... I didn't know that there is so much difference in prices between the two editions. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |