| Author |
 Topic Search  Topic Options
|
Amateur 
Senior Member
Joined: 22 July 2004
Location: Ireland
Status: Offline
Points: 210
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Sql Server Database Problem
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?
|
 |
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
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...
|
|
|
|
Amateur
Senior Member
Joined: 22 July 2004
Location: Ireland
Status: Offline
Points: 210
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
Amateur
Senior Member
Joined: 22 July 2004
Location: Ireland
Status: Offline
Points: 210
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 November 2006 at 5:17pm |
|
O ya, not using any of the 2005 features like clr, pivot etc.
|
|
Amateur
Senior Member
Joined: 22 July 2004
Location: Ireland
Status: Offline
Points: 210
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 November 2006 at 1:01am |
 Amateur wrote:
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?
|
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
Senior Member
Joined: 22 July 2004
Location: Ireland
Status: Offline
Points: 210
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 November 2006 at 11:41am |
Info_Tech wrote:
Amateur wrote:
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?
|
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. |
Is it not cheap enough -> http://www.amazon.com/Microsoft-SQL-Server-2000-Developer/dp/B000050AVLor am i missing something?
Edited by Amateur - 25 November 2006 at 11:41am
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
