Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Move Database from SQL2000 to MSDE
Message
De
27/03/2001 10:24:00
 
 
À
26/03/2001 10:24:20
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
00488381
Message ID:
00488976
Vues:
7
>>Have you tried to DTS from one server to the other. I know it takes time but DTS should know how to extract objects from 2000 and script them for 7.0.
>>
>
>No. Since the destination database is not available at "DTS" time, I didn't know what to specify as a destination. I guess I could set up an always empty MSDE machine to use DTS against, but that's not much less work than the other method I found that works.

You can set DTS to just output the scripts rather than run them against the target, also.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform