Information générale
Forum:
Microsoft SQL Server
I have had this problem too when copying table from one sql server to another. Im assuming your using the Data Import/Ecport wizard, which asks if you want to copy tables or copy objects. If you select copy tables, it does only that. You need to select copy objects to get it to include the indexes and relationships.
Eric
>I have to create database that made from importing Ms. Access 2000 MDB files into Ms. SQL 2000, it's done already with no errors but I do not understand why the index keys and also primary keys are not also imported... any solutions thanks
>
>Regards
>Teddy
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement