Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL2K -> SQL05 import index??
Message
 
 
À
06/06/2007 13:15:01
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
01231027
Message ID:
01231626
Vues:
9
>I have been working with the import wizard in SQL 05, pulling data from SQL 2K. The data comes across, but the primary key and index definitions are not there. Am I missing something??
>

The SQL Server Import Wizard main purpose is to copy data from a source to a destination. It's up to you to make sure that table definitions, including indexes, FK, CK, etc., on the destination are correct.
You may want to use the Copy Database Wizard instead if you're transfering whole DB.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform