Search and Replace Databases

Avoid the Need to Export and then Import!

A key consideration when searching and replacing inside databases is to avoid the need to export and then import the data again! This saves a huge amount of work, potential errors, data size issues, and allows others to continuously update and use the database without taking it offline.

To search and replace databases in-situ, a tool is required that connects to the database via the databases native drivers or ODBC/OLE DB.

Recommendation

We recommend the search and replace tool by DataMystic called DataPipe Search and Replace for Databases.

DataPipe supports both perl regular expressions and EasyPattern regular expressions.