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