moving a 2005 DB to 2000

I haven't tried this yet so forgive me.
But are there any issues with taking a database on SQL 2005 and putting
it on a machine that only has sql 2000? I know when you attach the 2000
DB in 2005 it does some type of upgrade - is there a cooresponding
"downgrade"?
Darin
*** Sent via Developersdex http://www.developersdex.com ***"Darin" <darin_nospam@.nospamever> wrote in message
news:uE%23qtqUHIHA.2100@.TK2MSFTNGP03.phx.gbl...
>I haven't tried this yet so forgive me.
> But are there any issues with taking a database on SQL 2005 and putting
> it on a machine that only has sql 2000? I know when you attach the 2000
> DB in 2005 it does some type of upgrade - is there a cooresponding
> "downgrade"?
> Darin
> *** Sent via Developersdex http://www.developersdex.com ***
No. You can't restore a 2005 database to a 2000 server and you can't attach
it either.
For schema objects the best option is probably to generate scripts. 2005
Management Studio gives you the option to generate backwards-compatible
scripts. For data, use BCP or DTS or link the servers and INSERT / SELECT
INTO.
Hope this helps.
--
David Portas|||Hello Darin,
There is no a direct way to accomplish this task however there are
workarounds. Check out the following page:
http://scottelkin.com/archive/2007/02/15/How-to-Downgrade-a-Database-from-SQL-Server-2005-to-SQL-Server-2000.aspx
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT
"Darin" <darin_nospam@.nospamever> wrote in message
news:uE%23qtqUHIHA.2100@.TK2MSFTNGP03.phx.gbl...
>I haven't tried this yet so forgive me.
> But are there any issues with taking a database on SQL 2005 and putting
> it on a machine that only has sql 2000? I know when you attach the 2000
> DB in 2005 it does some type of upgrade - is there a cooresponding
> "downgrade"?
> Darin
> *** Sent via Developersdex http://www.developersdex.com ***