General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2000
Sorry Sergey:
No, no duplicate data on the primary server.
The data on the primary database (server machine 1) is exported to the secondary database (server machine 2).
Sometimes I forget to export newly created records to the secondary database. Sometimes, forgetting I'd skipped an export, I'll export the next batch. Both databases should exactly be the same. So, when I forget to export data, they become out of sync.
Just wanting to know if SQL Server can help me correct my stupid mistakes.
Mal
>Are you saying that you have duplicate data on the primary server?
>How do you import data on the secondary server?
>
>>Hi Surgey:
>>
>>Thanks for taking the time.
>>
>>I've been manually updating both primary and secondary server. Manually meaning transfering data from a cd and/or stick to each server. Sometimes, I forget to transfer to the secondary server and all of a sudden the servers aren't sync'd.
>>
>>What I did was delete all records of the specific table on the secondary server and import the entire records from the same table on the primary server.
>>
>>I there a way to import and instruct SQL Server to ignore duplicat data?
>>
>>TIA
>>
>>Mal
>>
>>
>>>Are you using DTS to update destination table or something else?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only