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,
TimDetach 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|||Hi,
Backup SQL Server 2000 database, and restore it
regards
Vt
Knowledge is power;Share it
http://oneplace4sql.blogspot.com
"Norman Yuan" <NotReal@.NotReal.not> wrote in message
news:u3OaRrimHHA.4316@.TK2MSFTNGP06.phx.gbl...
> 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...
>