Saturday, February 25, 2012

Copy a SQL 2000 Server database into SQL 2005 Express

I have a database in SQL 2000 that I would like to move to SQL 2005 Express.
I could re-create all of the tables from scratch. Is there an easier way to
copy this database into SQL 2005 Express from SQL 2000 sever. I do not care
about the data, just the design.
Thanks,
Tim
Detach the database from SQL Server2000, copy *.mdf/*.ldf to the computer
where SQL Server2005 installed, attach the files to SQL Server2005.
"dbguru316" <dbguru316@.discussions.microsoft.com> wrote in message
news:18CEF436-E753-44CE-BA56-3AB09D32F248@.microsoft.com...
>I have a database in SQL 2000 that I would like to move to SQL 2005
>Express.
> I could re-create all of the tables from scratch. Is there an easier way
> to
> copy this database into SQL 2005 Express from SQL 2000 sever. I do not
> care
> about the data, just the design.
> Thanks,
> Tim

No comments:

Post a Comment