MySQL Database Tools - Data Administration, Migration, Business Intelligence, ORM

 

Commercial MySQL Tools

 

Active Business Intelligence Portal

Active BI Portal is business intelligence software that provides an integrated solution for designing and deploying reports and web forms over the internet and intranet. Active BI Portal consists of two parts Active BI Portal Manager which works on Windows only and server part which is collection of PHP scripts and can be run on Windows, UNIX or Linux. Active BI Portal works with all major commercial and open source databases.


Active Query Builder ASP.NET Edition

This software is the ultimate ASP.NET query builder, a component that will make building SQL queries easier than you could ever have imagined. Active Query Builder ASP.NET Edition provides web developers with the tool they need to build SQL queries visually, using a user-friendly interface in the style of Microsoft Access.


Active Query Builder Java Edition

Active Query Builder Java Edition is a visual component for Java environment to allow your end users to build complex SQL queries visually via user-friendly graphical interface easily. Active Query Builder renders all SQL features, such as sub-queries and unions, very easy to accomplish and provides the professional user with everything he or she needs to efficiently work with queries. It is a perfect choice for both SQL beginners and experienced query writers. By embedding Active Query Builder into your Java applets and applications, you can make it easy for beginners and provide a powerful tool for professionals.


Active Table Editor

Active Table Editor helps the users edit ANY table in ANY Database. Active Table Editor allows the administrator to log in and design the look of the application for the end users. You can edit user menus, security settings, menu items and input forms. All this complexity is left behind the scene for the end users. Once logged in, the end users see and edit the data, which was defined by the administrator. There is also an opportunity to use command line and in this way bypass login screen. The product works with all major commercial and open source databases.


AnySQL Maestro

AnySQL Maestro is a unique tool for administering any database engine (SQL Server, Oracle, MySQL, MS Access, etc.) which is accessible via ODBC driver or OLE DB provider.


BatchDeduplicator

The BatchDeduplicator is a program for regular doublet searches performed in address tables on a fixed schedule, in order to ensure the long-term quality of this data. Particularly repetitive advertising in the case of direct marketing and the unnecessary repeated maintenance of client and other address data can thus be avoided. Of course, this leads to a direct savings of costs. Furthermore, a doublet search between two tables can also take a list of customers who do not wish to receive marketing transmissions into consideration, which can save a lot of trouble.


DAC for MySQL

DAC for MySQL (also known as MySQLDAC) is the most powerful component suite for Delphi/C++Builder/MySQL. This component suite allows you to create Delphi/C++Builder applications with direct access to MySQL DB without BDE and ODBC. BLOB fields are supported. MySQLDAC was developed for easy migration of existing projects from BDE/ODBC scheme to the native one. Any MySQL library is not required. TDBImageEx component for JPEG images support included in package for free (with sources). DAC for MySQL(tm) is a royalty-free product.


Data Access Components for MySQL

Data Access Components for MySQL (MyDAC) is a VCL/VCL.NET/CLX component library for fast direct access to MySQL from Delphi, C++Builder, and Kylix. MyDAC is heavily performance- and stress-tested to provide the fastest available native connectivity to MySQL. MyDAC features full support for all MySQL data types and features, including support for locking, SET and ENUM types.


Data Archiving

By using Solix Enterprise Data Archiving the performance of the application is restored up to 50% by archiving those data which has been underutilized. Normally data gets stored in Tier 1 storage system but Enterprise Data Archiving stores data in less expensive Tier 2 storage. The advantage of Data Archiving is that the organization can cut on IT costs as it no longer needs large data sets.


Data Loader

Data Loader is a simple yet powerful tool to import and export Data between many common formats. Current Data Loader Ver. 3.0 supports MS-SQL Server, MySQL, Oracle, MS Access, FoxPro, DBF's, CSV & Delimited or Flat Files. You can use Data Loader to transfer data from one database format to another database format. While transferring you can filter columns and specify WHERE conditions. It supports Long , Picture Data types.


Database Workbench

Database Workbench is a multi-database tool with specifics for each supported engine. It supports editing metadata, running queries and scripts, transferring data, importing and exporting, printing metadata and much more. Supported database systems: - MySQL - Oracle - Firebird - Microsoft SQL Server - InterBase - NexusDB


DatabaseSpy

Altova DatabaseSpy 2007 is the unique multi-database data management, query, and design tool from the creators of XMLSpy. DatabaseSpy connects to all major databases, easing SQL editing and database structure design, for a fraction of the cost of single-database solutions. The Database Browser clearly presents your tables, views, and data in easily negotiable windows. The DatabaseSpy SQL Editor facilitates query writing with capabilities like code completion, syntax coloring, drag & drop construction, and more. And the powerful Database Design Editor enables graphical design and visualization of database structures or schemas.


DataQualityTools

DataQualityTools is a collection of tools to help businesses improve the quality of their databases. The central components are a series of functions which help to find duplicate records and, above all, a function for error-tolerant doublet search based on postal addresses. This allows you, in the case of direct marketing, to avoid double solicitations and the redundant maintenance of customer addresses and other records.


DB Data Generator

DB Data Generator is a simple, powerful data generator that allows developers to easily populate databases with thousands of rows of meaningful and syntactically correct test data for database testing purposes.


DBConvert for Excel & MySQL

DBConvert for Excel & MySQL is a reliable bi-directional database migration tool which allows you to convert data from: MS Excel to MySQL, MS Excel to MySQL Dump, MS Excel to PHP Script, MS Excel to MS Excel, MySQL to MS Excel, MySQL to MySQL, MySQL to MySQL Dump, and MySQL to PHP Script.


DBConvert for Firebird and MySQL

DBConvert for Firebird and MySQL is a database migration tool which performs two-way conversion from Firebird databases to MySQL server and from MySQL to Firebird. The tool is also applicable for MySQL database migration to another MySQL database and is quite adept at copying a Firebird database to another Firebird database. It handles conversion of InterBase databases too.


DBConvert for FoxPro & MySQL

DBConvert for MS FoxPro & MySQL is a database migration tool for data conversion from MS FoxPro database to MySQL server and MySQL db to Microsoft FoxPro. You can convert FoxPro to MySQL or MySQL to FoxPro simply by configuring several options through Wizard interface or in command line mode. The ability to organize application work using command line parameters is supplemented with a scheduler so you can run the program without user control after task scheduling.


DBConvert for Oracle and MySQL

DBConvert for Oracle and MySQL is a database migration tool which performs two-way conversion from Oracle databases to MySQL server and from MySQL to Oracle. The tool is also applicable for MySQL database migration to another MySQL database and is quite adept at copying a Oracle database to another Oracle database.


DBConvert for SQLite & MySQL

DBConvert for SQLite & MySQL is a database migration tool which performs two-way conversion from SQLite databases to MySQL server and from MySQL to SQLite. The tool is also applicable for MySQL database migration to another MySQL database or to MySQL server and is quite adept at copying a SQLite database to another SQLite database.


dbExpress drivers

dbExpress is a database-independent layer that defines a common interface to provide fast access to SQL database servers. For each supported server, dbExpress provides a driver as an independent library that implements the common dbExpress interfaces for processing queries and stored procedures. As a thin and simple data-access layer, dbExpress provides high performance database connectivity and is easy to deploy.


dbForge Data Compare for MySQL

dbForge Data Compare for MySQL is a fast, easy-to-use tool to compare and synchronize data of MySQL databases. You can quickly analyze data differences in a well-designed user interface and synchronize comparison results in a convenient wizard with additional options.


dbForge Fusion for MySQL, Visual Studio Add-in

dbForge Fusion for MySQL (formerly known as MyDeveloper Tools) is a powerful add-in designed to simplify the MySQL database application development process. It integrates into Visual Studio, making all database development and administration tasks available from your favorite IDE. It provides an easier way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different ways.


dbForge Query Builder for MySQL

dbForge Query Builder for MySQL is a brand-new solution for quick creation of queries and extended data management. It allows creating any complex queries effortlessly. The main component of Query Builder is a visual diagram where one can "draw" a query. It provides the easiest way possible to add tables, create joins, edit conditions.


dbForge Schema Compare for MySQL

dbForge Schema Compare for MySQL is fast easy-to-use tool to compare and synchronize structures of MySQL databases. This product is specially designed to help you quickly analyze database structure differences at a glance and propagate the changes to a required MySQL Server escaping tedious manual work.


dbForge Studio for MySQL

dbForge Studio for MySQL (formerly known as MyDeveloper Studio) is a powerful development environment for working with MySQL. dbForge Studio for MySQL provides an easier way to develop SQL scripts and stored routines, create and execute queries, manage users and privileges, explore existing databases, modify schema objects, export and import data, create database projects, and more.


DBForms from MS Access to PHP + MySQL

DBForms from MS Access to PHP + MySQL is an application to convert Microsoft Access databases (mdb) and MS Access Forms to AJAX based WEB page using PHP and MySQL. Now you can easily convert forms and their elements to Web page, filling form fields with data from the fields of your Access tables.


dbQwikSite Developer Edition

Easily create advanced database web sites. This amazing website development software combines state-of-the-art web code generators for ASP and PHP with the ability to inject your own custom code. The resulting pages are a hybrid of generated code and custom code. A great web development tool for both professional web developers and novices. Novices, can leverage the code generator to create fully functional pages, without any coding required. Professional web developers can use code generation to rapidly construct working sites but never be confined by the limits of the generated code.


DBSync for Firebird and MySQL

DBSync for Firebird and MySQL is a database synchronization tool which performs two-way conversion and synchronization from Firebird databases to MySQL server and from MySQL to Firebird. The tool is also applicable for MySQL database replication to another MySQL database and is quite versed in copying a Firebird database to another Firebird database. It handles conversion and synchronization of InterBase databases too.


DBSync for MS FoxPro & MySQL

DBSync for MS FoxPro & MySQL is a database synchronizer which performs MS FoxPro to MySQL and MySQL to FoxPro database conversion and synchronization simply by configuring several options in a wizard-like application. It gives you a chance to not only convert your data with synchronization, but also to choose a particular number of tables to be converted and organize application work using command line parameters, choosing whether to copy the identical records from source database to the destination database or not. The program provides high speed synchronization and gives the opportunity to select Insert, Update and Drop types of synching. All options selected initiate full database synchronization. You can check each program step with savable log files and run again synchronization with stored session files that keep all your settings.


DBSync for Oracle and MySQL 1.0.0

DBSync for Oracle and MySQL is a database synchronization tool which performs two-way conversion and synchronization from Oracle databases to MySQL server and from MySQL to Oracle. The tool is also applicable for MySQL database replication to another MySQL database and is quite adept at copying a Oracle database to another Oracle database.


DBSync for SQLite & MySQL

DBSync for SQLite & MySQL is a reliable bi-directional database migration tool which allows you to synchronize and convert from SQLite to MySQL or from MySQL to SQLite with the ability to copy the whole database as well as to convert particular tables, fields, indexes and foreign keys by simple configuring of several options through a Wizard interface or in command line mode.


Debugger for MySQL

Debugger for MySQL is a powerful solution for managing and debugging stored MySQL procedures and functions of any complexity. The software features standard debugging tools, such as watches, conditional breakpoints, an expression evaluator and a call stack, and enables you to take advantage of some of its unique functions, such as the SQL Window.


dotConnect Express for MySQL

dotConnect Express for MySQL is a free of charge enhanced database connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies. dotConnect offers a complete solution for developing database-related applications and web sites. With state of the art ORM solutions such as Entity Framework and LINQ to SQL, it introduces new approaches for designing applications and boosts productivity of database application development.


dotConnect for MySQL

dotConnect for MySQL is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies. dotConnect offers a complete solution for developing database-related applications and web sites. With state of the art ORM solutions such as Entity Framework and LINQ to SQL, it introduces new approaches for designing applications and boosts productivity of database application development.


dotConnect for MySQL

dotConnect for MySQL is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies. dotConnect offers a complete solution for developing database-related applications and web sites. With state of the art ORM solutions such as Entity Framework and LINQ to SQL, it introduces new approaches for designing applications and boosts productivity of database application development.


FlySpeed Data Export

Extract and export data from databases in a variety of formats automatically. FlySpeed Data Export provides direct access data export from numerous databases such as Oracle, MySQL, MS SQL Server, and supports PostgreSQL, Firebird, DB2, Sybase, Informix, dBASE and many other databases via ODBC or OLE DB.


FlySpeed SQL Query

Build SQL queries easier with a visual query builder. FlySpeed SQL Query allows new and professional database developers to build complex SQL queries in a simple graphical manner. Compatible with multiple types of databases, FlySpeed SQL Query can perform queries on different database servers and various platforms without requiring knowledge of SQL. Viewing and analyzing the results is also easy thanks to the ability to print the results and export data.


forSQL Data Generator

forSQL Data Generator is an automatic data generator for large scale database testing and Quality Assurance. It lets database developers and testers automatically generate test data to fill a database with logically correct and realistic test data. This saves countless hours and even days that would otherwise be wasted on entering and configuring the data manually.


Habanero Pro

Habanero is an object-relational mapping (ORM) architecture for .Net that maps object-oriented code to relational databases. It persists data to and from the database and generates user interfaces to edit the object's properties. Habanero can read class design from the database and generate code for the business objects to be mapped.


HoneyMonitor - GUI for MySQL

HoneyMonitor is a nice, easy to use and powerful tool for MySQL administration, monitoring and performance tuning targeted at developers and DBAs who daily need to manage databases and monitor servers' status. An advanced query builder, a fine report designer, code assistance features, cluster management features, and master/slaves replication management features are also included making HoneyMonitor a professional choice for MySQL administration in Windows systems.


microOLAP Database Designer for MySQL

MicroOLAP Database Designer for MySQL is a visual development system intended for database design, modeling, creation, modification and reverse engineering in an easy and powerful way. MicroOLAP Database Designer for MySQL allows you to construct your database in easy-to-understand visual environment by working with graphical representation of tables, columns, relations and so on. Finally you will get Physical Entity Relationship Model (ER Model) that can be exported in SQL script, or directly built on working MySQL database server.


MySQL Workbench

MySQL Workbench enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases. It includes everything a data modeler needs for creating complex ER models, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.


ODS

ODS is an automatic database and DAL source code generation tool aimed at .NET Framework 2.0+ software developers who want a custom database and DAL to use with their application. Rather than using an existing database, ODS allows you to design the objects that you want to store. ODS then automatically designs both a database to store them in and generates a corresponding DAL.


OpenAccess ORM

Telerik OpenAccess is an Enterprise-grade .Net ORM that does the data access plumbing in desktop and web applications. Supporting forward (model-first) and reverse (schema-first) mapping, the tool offers transparent persistence for your DAL and business objects. OpenAccess ORM provides tight Visual Studio integration and allows you to seamlessly create database independent code. Take full control of the mapping process and generated model with the powerful Visual Designer for OpenAccess ORM and the advanced features for code optimization and caching.


SQL Examiner Suite

Supporting SQL Server, MySQL and Oracle, SQL Examiner Suiteis the ultimate solution for SQL compare and synchronization of both data and schema in your databases. SQL Examiner Suite 2010 is a combination of two important and highly useful tools. These tools are SQL Examiner 2010 and SQL Data Examiner 2010. The tools run efficiently on any database supported. They also work with database creation scripts and SQL Server database backup files as well. Full automation of processes is also supported with the built-in command line comparison and synchronization feature. Source control systems including SourceSafe, Perforce, SVN and TFS are also supported which helps to keep databases under version control.


SQL Maestro for MySQL

SQL Maestro for MySQL is the premier MySQL admin tool for database management, control and development. Key features include: - all versions of MySQL Server including MySQL 5.0 and 5.1; - easy database object management; - database designer; - data management: viewing, editing, grouping, sorting and filtering abilities; - comfortable access to the MySQL security features; - handy SQL editor with code folding, syntax highlighting, and multi-threading; - visual query builder; - possibility to connect to remote servers via SSH or HTTP tunnel; - data export/import to/from the most popular formats; - powerful BLOB viewer/editor.


SQLWays

SQLWays is a database and application migration product capable of converting stored procedures, functions, triggers, database schema (DDL), data, SQL queries, scripts and applications. SQLWays guarantees migration process optimization to reduce your project costs. Support team offers individual comprehensive product customization in order to meet all your individual and specific requirements. SQLWays offers up to 100 percent automation of the entire migration process with reasonable pricing strategy.


Universal Data Access Components

Universal Data Access Components (UniDAC) is a powerful library of nonvisual cross-database data access components for Delphi, Delphi for .NET, and C++Builder. We combined experience of long-term successful development into one great product, which provides unified access to popular databases such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL, SQLite, InterBase, and Firebird.


Visual Importer Enterprise

Visual Importer Enterprise automates the process of loading data into any database. It enables the user to design Import, Export and SQL scripts, add them to the package and schedule it for execution on regular basis. It stores all information in the repository. Supported repository types include MS Access (default repository), Oracle, MS SQL Server, Interbase, MySQL, and PostgreSQL. Typically Visual Importer Enterprise is used to download files from an FTP server, load them into the database, run stored procedure or SQL script and send email to the admin, once the package is completed.


Visual Importer Professional

Visual Importer Professional automates the process of loading data into any database. It enables the user to design Import, Export and SQL scripts, add them to the package and schedule it for execution on regular basis. All objects are stored in the repository. Supported repository types include MS Access (default repository), Oracle, MS SQL Server, Interbase, MySQL, and PostgreSQL.


xSQL Documenter 1.0.0

Comprehensive, uniform, and easily navigable database documentation for all your applications. Generates documentation in HTML and CHM format; supports all major database management systems: SQL Server, Oracle, DB2, MySQL, Informix IDS, Sybase ASE, PostgreSQL, Access, VistaDB, ENEA Polyhedra; can run as a console application; documentation can be branded; supports XML comments added to your objects and a lot more.