copy 7.0 database to 2005

Hello,

What is the best way to copy a SQL Server 7.0 database to SQL server 2005.
Currently we backup the 7.0 database, restore it to 2000, backup the databas
e
on 2000, restore it to 2005.  Is there a better way to do it? And can it be
automated?

..A little background.. Our production databases are on 7.0 and we are
developing a new system on 2005 backend.  We often need to refresh our data,
so we like run the 7.0 to 2005 procedure at least onece a day.

thanks

Why don't you just restore the 7.0 backup onto the 2005 server?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON   Canada
www.pinpub.com
.
"Pete" <Pete@discussions.microsoft.com> wrote in message
news:CB7BCCF7-2FCD-47CE-A7FB- AA37F55222EA@microso
ft.com...
Hello,

What is the best way to copy a SQL Server 7.0 database to SQL server 2005.
Currently we backup the 7.0 database, restore it to 2000, backup the
database
on 2000, restore it to 2005.  Is there a better way to do it? And can it be
automated?

..A little background.. Our production databases are on 7.0 and we are
developing a new system on 2005 backend.  We often need to refresh our data,
so we like run the 7.0 to 2005 procedure at least onece a day.

thanks