Exporting Data Introduction

 

The Duplicate Record Remover tool works on its own internal copy of your data, so the edits and merges you process with the Processing Tool are only applied to that internal copy of your data.

This means you will need to get the changes (edits, updates and deletes) you have applied during processing and apply them to your live data.  There are a number of different options available for getting these changes applied to your live database.

Click the  button in the Processing Tool to open the Export Data window:

 

 

You have the following three options to export cleaned data:

1)    Raw cleaned data: You can export the raw cleaned data from the internal data store (as CSV, Excel or XML)

2)    Changes made to clean the data: You can export the changes made to your original data during the cleaning process.  These changes (sometimes called delta’s) show you what needs to happen to your live database in order to eliminate the duplicates you have found.  These can be exported as either XML (for a programmer to use to automatically update the live data) or T-SQL (update scripts for a database administrator to run against your SQL database).

3)    False duplicates for future duplicate examinations of your data: These are used if you were to re-examine your database again at a later date and wanted to avoid having to re-process the false duplicates you have found.

 

 

Related Topics

Exporting Data