Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to copy database to another server?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
00392501
Message ID:
00392521
Vues:
15
This message has been marked as the solution to the initial question of the thread.
>Is there another way to copy a database to another server without using DTS?

You have a couple of options.
1) Backup the database and restore it to the target server
2) If you're using SQL Server 7.0, you can detach the database, copy the file to the target server, and attach the database to the target server.
3) You can use the SEM to generate a script that will recreate the schema and use BCP to move the data (this could be a lot of work!).
4) DTS with the Object Transfer option if you're going between SQL Server 7.0 servers.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform