Editor's review
Making corrections in large sized database often turns out to be a hectic affair for the database administrators as it takes hours of labor to find a specific item from the vast content and replace it with correct data. Well, if you also have confronted such a problem and wish to release the burden of this cumbersome task, then try using DataPipe Database Search Replace 3.8. It’s a great utility that aids you in searching and replacing data inside any database, thus helping you in fixing garbage data, changing embedded UNC paths, removing binary characters, correcting capitalization, and even more. The program also lets you extract email address from the contacts database for your CRM campaign. The utility supports command line operation, complete audit logs providing information of filters used with the changes made. It consists of over 100 filter files accompanied by a detailed user manual for aiding users.
With the DataPipe Database Search Replace sports an intuitive interface comprising of easily-negotiable features. For beginning the correction process, first you’d have to define OLE DB/ODBC data source for establishing connection with the database. For example you’ve selected contacts database and want fix capitalization. Now, you’d be shown the entire tables of the database within a drop down list in Query tab, after which you can either choose retrieving data from any table or write SQL query. Choosing any of the data like Customers, press ‘Preview data’ button that displays the relevant data within rows and columns in Original Data tab. Now for correcting Customer Name field, select it and press next to further set filters for transforming and fixing the errors. You can have preview the output after applying the filter. Within the Preview Changes you can even make manual change to any name if required. Press ‘Go’ and the program would make the necessary corrections.
DataPipe Database Search Replace helps you in making changes and corrections in any database, instantly. The utility deserves to be rated with 4.5 points for its excellent functioning and credible and impressive option-set.
User comments