Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Move SQL database to client site
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01259630
Message ID:
01259880
Views:
24
>Thanks. At least I know that I'm in the right directory! It's odd that Copy isn't an option there but I can't "see" the SQL 7 installation with SSMS anyway.
>
>Obviously I can't use Copy. Restore won't work because of version differences. Even the script that I created in 7.0 won't create a valid 2005 database. I just don't know what else to try....

I've never dealt with SQL 7 databases so I'm just guessing now, but one option that Sergei mentioned may be needed if you can not attach or restore the 7.0 database in 2005.

(this is assuming the 7.0 database size is less than 2GIG - otherwise you'll need SQL Server 2000)

Install MSDE on a server or workstation, attach the database using that, and then back it up in MSDE. That will restore in SQL 2005.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform