October 10, 2008 at 8:47 am
Hi folks,
Just wanted to pick everyone's brain about this issue i have come across. I'm new to SQL and still finding my way. Bear with me.
We have 5 sql server 2000 servers and we have just added two sql 2005 servers. We have taken a database from sql 2000 and moved it to the sql 2005 server. This is working fine.
The problem we are coming up against is that all of our local development servers are running sql 2000. We tried to download a live 2005 database and restore it locally on 2000. I know this will not work but is there a way we do this.
I have come across the compatibility feature but havent quite got my head around how it works yet. Just going to have a look into it. Will the compatibilty mode allow us to do what we want. Are there any performance drawbacks or is it just a case of needing to get a SQL 2005 local server.
Thanks in advance
October 10, 2008 at 8:52 am
No.
You cannot in any way restore a SQL 2005 database backup on a SQL 2000 server. Compatibility mode will not help you.
Your only option would be to copy the database structure and data with some kind of ETL tool. MS does not give you any assistance with "downgrading".
October 10, 2008 at 8:53 am
To add to this, it is a bit risky to develop on one version of a database and have your production systems running on another. They behave differently - you could find that queries run on the SQL 2000 version of the database do not perform well on the SQL 2005 version.
October 10, 2008 at 9:42 am
Thanks for the quick response, much appreciated. Looks like we are looking at getting a seperate 2005 server then!
Cheers
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply