Introduction
|
|
|
Introduction |
|
|
|
|
|
|
|
|
|
|
|
|
|
What does the Find Duplicates Wizard do? The Wizard allows you to quickly and accurately identify duplicate data within a Microsoft® SQL Server™ 7 or 2000 database table that you specify. All duplicates processing takes place on the server, which allows you to leverage the power of the server directly, for the fastest possible results. The Wizard is highly configurable, taking you way beyond the sort of results you can obtain by just hand-coding some SQL. For example, it lets you define up to 256 different column-combinations to use in a single analysis (each combination being an 'analysis key'), and it will perform extremely powerful inter-key analyses for you at the press of a button. Once a find duplicates analysis has been completed, the analysis results are stored in the database, in one (sometimes two) separate tables, ready for you to work with. You can then review those results using the Wizard's built-in data viewer, where you can also fine-tune results by running ad-hoc SQL against the server (if you wish) and you can also export your analysis results to a variety of external file formats. To see what it all looks like, please take a look at our Screenshots page. Who is this product intended for? The Find Duplicates Wizard is useful to anyone who works with, or is responsible for data within a SQL Server™ 7 or 2000 database. Users need to have a basic understanding of database tables, and what an index is for, but that's pretty much all. A computer which uses this program needs to be able to connect to SQL Server™ using ODBC (Microsoft's Open Database Connectivity). You don't need to understand ODBC especially, but you will be using it. Chances are, you already do anyway. Note that the program generates and displays SQL (Structured Query Language) in order to produce its results data. If you are not familiar with SQL, don't worry - you can enjoy full benefit from the Wizard without ever knowing any SQL at all. However, if you do know SQL, you may find the generated scripts useful (and the ad-hoc SQL facility too), but those things are just a bonus. So whether you are a DBA (Database Administrator) or a Marketing Executive trying to assess the quality of some name and address data, you can still enjoy the full benefits that the Wizard has to offer. Further reading... Please also see the FAQ page and the Technical page. If you would like to obtain more detail on what the Wizard has to offer, the program's Help file contains a comprehensive, illustrated description and is available on our download page. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
