Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Avoiding Duplicate Records
Message
 
 
To
07/08/2008 19:28:55
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01337412
Message ID:
01337448
Views:
18
Are you using DTS to update destination table or something else?

>
>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?
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform