Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Move SQL database to client site
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01259630
Message ID:
01259880
Vues:
23
>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!
____________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform