Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database migration
Message
De
29/08/2006 11:03:33
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01149193
Message ID:
01149377
Vues:
9
>>I have several old servers that I need to migrate to several new virtual servers. Migrating the data (tables, procedures etc.) is not a problem. Transferring the users, roles, groups, and the backup jobs, and other jobs may prove very manual. The servers will not go one-to-one, so simply migrating the msdb and master will not work.
>>
>>What problems might be foreseen in trying to concatenate the msdb and or master dbs??? Is it even possible? If not, what might be the best solution??
>
>You can use Copy Database Wizard or DTS Import/Export Wizard.

Thanks for your reply Sergey! Do you know of the dependability of this wizard? It would seem to have the utilities needed, but I have only used the Copy Database Wizard once, and while it worked fine that time, I need a very dependable method. It's kind of an 'all the eggs in one basket' scenario, and there are a lot of eggs. :)
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform