SQL Find Duplicates Tool »
SQL Find Duplicates Tool allows database administrators to clean up their databases without the need for hours of tedious, risky work or complicated programming.
It can locate duplicate records (defined by selecting which columns to search) in your database within seconds. SQL Find Duplicates Tool is a must for any database
administrator or software company that works with SQL Server 2000 databases.
|
 |
Features
 |
Compatible with SQL Server 7, 2000 and MSDE |
| |
SQL Data Scripting Tool works with both the full version of SQL Server 7, SQL Server 2000 and the free version, MSDE. The product has also been tested with SQL Server 2005 Beta 2. |
|
No Schema Changes Necessary |
| |
Absolutely no schema changes to your database are necessary, as long as there is already a column which contains a different value for every row in the table. If there is no such column, you can still use the product by simply adding an identity column to the table. |
|
Use non-Primary Key Columns as the Distinct Column |
| |
Any column can be selected as the distinct column, not just primary key columns. |
|
Combine Multiple Columns in the Query |
| |
SQL Data Scripting Tool allows you to select multiple columns to define what constitutes a unique (non-duplicate) row in the database. By searching only certain columns, you can find out if particular columns, such as email or postal addresses, contain unwanted duplicates. |
|
Automatically Delete Duplicate Data |
| |
SQL Data Scripting Tool can also delete duplicate records from the database, allowing to you to quickly and safely remove unwanted data, after viewing duplicate records. |
|
Allows Non-Programmers to Clean Databases |
| |
The easy-to-use wizard interface allows non-programmers can perform data cleanup operations on a database, as it is not necessary to write SQL code. |
Screenshots
|
System Requirements
- Microsoft .NET Framework 1.1
- Microsoft SQL Server 7, 2000 or MSDE
- Microsoft Data Access Components (MDAC) 2.8 or later
- Microsoft Windows 2000, XP or Server 2003
- Minimum 64 MB RAM
Pricing
Single License: $49 AUD (ex GST)
$53.90 (inc GST)*
Each computer running the software requires a separate license.
*GST is applicable to Australian residents and Australian-based organizations only.
Pricing is subject to change without notice.
All of our products come with free lifetime technical support via email.
Related Links
|
Looking to download a free 30-day trial? Visit Downloads
page. |
|
Need assistance setting up or using one of a products? Have a question about
one of your products? Try the Knowledge Base,
or contact Technical Support |
|
Ready to Purchase? Go to our Online Shop
|
|
;)
;)
;)