|
Home > Archive > MS SQL Server > February 2006 > copy 7.0 database to 2005
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| Tom Moreau 2006-02-28, 8:23 pm |
| 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
|
|
|
|
|