Search and replace inside databases. Fix garbage data, remove binary characters, change embedded UNC paths coded in your database.
DataPipe interactively or automatically search/replaces data in ANY table. You can correct capitalization in people's names (a solution to the old problem), standardize formatting of addresses (eg PO Box, P.O. Box, POBOX), extract email addresses (for your next CRM campaign), search and replace using advanced pattern matching, fuzzy matching and sounds-like matching (multiple search and replace operations occur in a single pass through the database), trim blanks and multiple whitespace, remove binary characters ("garbage" characters), remove HTML, XML and SGML, convert between ASCII and EBCDIC, OEM and ANSI, Unicode and ANSI, insert or remove text within a column, force text to a specified width, write your own VBScript or JScript (or PerlScript, PythonScript, REXXscript etc) code against columns (and access COM objects) and MUCH more!
Sub filters can identify text subsets such as a range of lines or columns to be operated on without affecting any other text. This makes it easy to only perform a replacement in lines 1 to 10, or in columns 3 to 20. Other sub filters include CSV- or tab-delimited fields, lines that match or do not match a pattern, and search replacements (allowing replacement text to be capitalized etc).
DataPipe can be fully automated from the command line. Full audit logs keep track of the filters run and changes made. More than 100 example filter files are included along with a comprehensive user manual. DataPipe fully supports language translations.
DataPipe requires you to download TextPipe Pro, and you get TextPipe Pro FREE when you buy DataPipe - so you can use it for cleansing text files and database extracts as well!
Database Design Studio - Professional (DDS-Pro) 2.21.1
DDS-Pro is for reverse engineering databases, ERD modeling, SQL script generation and forward engineering of relational databases. Enhanced Entity Relationship Diagram modeling allows you to design a fully relational database, complete with...
Price: USD $299.00;
File Size: 10393 KB;
Platform: Windows 95, Windows 98, Windows Me, Windows NT, Windows 2000, Windows XP
Aqua Data Studio 4.5.2
Aqua Data Studio is a SQL editor and developer tool that allows developers to easily create edit and execute SQL scripts as well as browse database structures. Aqua Data Studio provides an integrated database environment with a single consistent...
Price: USD $149.00;
File Size: 50822 KB;
Platform: Windows 95, Windows 98, Windows Me, Windows NT, Windows 2000, Windows XP, Linux
ESF Database Convert 4.8.5
1). The ESF Database Convert software is wizard-like; it's so easy and quickly, everyone can use it. You convert one database to the other just only 3 steps;
2). Supports various database formats. It can interchangeably convert MySQL, SQL Server,...
Price: USD $99.00;
File Size: 1535 KB;
Platform: Windows 98, Windows Me, Windows NT, Windows 2000, Windows XP, Windows 2003
SQL Diagrams 2004
A graphical overview of your database solution. *** Don't spend hours trying to understand your database, see it with SQL Diagrams. *** For the first time you can graphically understand, how your tables, views, SPs, UDFs, triggers and other...
Price: USD $49.00, EUR 44;
File Size: 6276 KB;
Platform: Windows 95, Windows 98, Windows Me, Windows NT, Windows 2000, Windows XP, Windows 2003
SQLyog MySQL GUI 4.1
SQLyog is a compact Win32 Front End for the MySQL database server. The program is aimed at users that are familiar with SQL statements and need an easy to use, no fuss, graphical interface to execute SQL queries. The program supports execution of...
Price: USD $0.00;
File Size: 34816 KB;
Platform: Windows 3.x, Windows 95, Windows 98, Windows Me, Windows NT, Windows 2000, Windows XP
4TOPS Excel Import for MS Access 2000 3.24
4TOPS Excel Import Assistant is an excel import utility for all your access excel import needs. Use it to import excel to access in a controlled way. Moving row after row through your Excel table(s) you can instantly fill in missing data or alter...
MySQL PHP Generator 7.4
MySQL PHP Generator is a freeware but powerful MySQL GUI frontend that allows you to generate high-quality MySQL PHP scripts for the selected tables, views and queries for the further working with these objects through the web. Key features...
Price: USD $0.00;
File Size: 3266 KB;
Platform: Windows XP, Windows NT, Windows Me, Windows 98, Windows 95, Windows 2003, Windows 2000
ODBC Explorer 1.1.9
ODBC Explorer is an easy-to-use database tool for Win32. It offers many powerful features for database administrators and programmers. This tool is based on ODBC DAC and works with ODBC drivers directly without any intermediate layers. Using ODBC...
Price: USD $49.00;
File Size: 0 KB;
Platform: Windows 95, Windows 98, Windows Me, Windows NT, Windows 2000, Windows XP
DB Explorer 2.2.2
DBExplorer is a powerful database utility that allows you to compare any two databases and report the structural and data differences between them. It then enables you to synchronize the differences. This can be done on selected tables or data....
Universal SQL Editor 1.1.1
Universal SQL Editor is a powerful, yet easy-to-use graphical query tool for all database developers. It allows you connect any ODBC compliant databases, such as Oracle, DB2, SQL Server, Sybase, etc., and edit SQL queries and scripts with code...
Price: USD $39.00;
File Size: 1286 KB;
Platform: Windows XP, Windows NT, Windows 2003, Windows 2000
