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.
thanksWhy 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@.microsoft.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