sql 2000 to sql 2005

Hi

How can I move a sql 2005 db (data and all) to sql server 2000? I have made
the mistake of developing on sql server 2005 and now found out that
production server is still 2000.

Thanks

Regards

I'm somewhat sure you cannot backup & restore a 2005 to 2000, nor can you
detach/reattach.  You'll need to script out your stuff, move it over, or
perhaps create an SSIS package to move the objects & data.

"John" wrote:

> Hi
>
> How can I move a sql 2005 db (data and all) to sql server 2000? I have mad
e
> the mistake of developing on sql server 2005 and now found out that
> production server is still 2000.
>
> Thanks
>
> Regards
>
>
>