|
Home > Archive > MS SQL Server Tools > March 2006 > sql 2000 to sql 2005
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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 made
> the mistake of developing on sql server 2005 and now found out that
> production server is still 2000.
>
> Thanks
>
> Regards
>
>
>
|
|
|
|
|