Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Avoiding Duplicate Records
Message
 
 
À
07/08/2008 19:28:55
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01337412
Message ID:
01337413
Vues:
19
>Hi:
>
>I have 2 locations each with a SQL Server machine. One machine is alwasy updated. I use EXPORT from the updated machine then IMPORT into the other machin to keep the machines the same. This has been working out, but recently I've been getting duplicate recrods. How do I implement an IMPORT and elimnate/ignore dulicate records. Is there a way to tell SQL Server's Import to ignore records already in the table?
>
>TIA
>
>Mal

Mal,

I'm not sure it's the right answer, but you can always add a check after your process is done and eiliminate duplicates.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform