Database Tools

EMS Data Pump for MySQL is an excellent utility for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MS SQL database or any other database with ADO support) to MySQL databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target MySQL database and select tables for import. Database conversion becomes as easy as possible with Data Pump for MySQL!

EMS DB Comparer for MySQL is an excellent tool for database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to eliminate all or selected differences. Having EMS DB Comparer for MySQL you can work with several projects at once, define comparison parameters, print difference reports, and alter modification scripts. Its user-friendly interface greatly simplifies discovering and eliminating differences in MySQL database structure saving your time and therefore money.

EMS Data Generator for MySQL is a powerful utility for generating test data to several MySQL database tables at once. The wizard application allows you to define tables and fields for generating data, set value ranges, generate char fields by mask, load values for BLOB fields from files, get lists of values from SQL queries and many other features to generate test data in a simple and direct way. It also provides you console application, which allows you to generate data in one-touch by using generation templates.

EMS DBISAM Manager provides you with powerful tools for DBISAM Server administration and object management. Its Graphical User Interface (GUI) allows you to easily and simply create/edit all DBISAM database objects, run SQL scripts, manage users and administer user privileges, visually build SQL queries, extract and print metadata, export/import data, view/edit BLOBs, and supplies many more features that will make your work with the DBISAM server as easy as ABC.

EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML columns, and so on. It offers plenty of powerful tools for experienced users such as Visual Database Designer and Visual Query Builder to satisfy all their needs. SQL Manager 2005 has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

EMS SQL Manager for InterBase/Firebird is a powerful tool for InterBase and Firebird administration and development. SQL Manager 2005 is compatible with any Firebird version up to 2.0 and InterBase version up to 7.5 and supports all of the latest features including trigger messages, BLOB filters, and so on. It offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder and Stored Procedure Debugger to satisfy all their needs. SQL Manager 2005 has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

This article discusses a solution to import MS Excel, MS Access, XML data to local or Remote MySQL databases by using a famous MySQL Admin Tool called Navicat. We very often need to import various data into MySQL databases. This becomes a tough job if we don't have a reliable & easy-to-use MySQL GUI; At times, when I am working on deadlines, this job becomes frustrating and I find myself wishing I had a tool to do this job for me. Navicat can convert Excel spreadsheets /MS Access to MySQL databases, eliminating time-consuming data entry and the errors that accompany it. It uses a Microsoft Access-like interface and comes with a MySQL server Launcher and comprehensive manual that will help you to get started. It is more than just a simple MySQL admin client, other useful major features include schedule backup, data transfer, import/export wizard, support Foreign Keys, visual query builder, and visual report builder.

Full Convert provides you with comfortable way to convert data between many different databases. For highest possible speed and reliability, Full Convert uses native access to databases wherever possible. Currently, native connections are used for Interbase/Firebird, MySQL, Oracle and SQL Server databases. Full Convert 1.0 supports following databases (future version will support even wider variety of data formats) - Microsoft Access - dBase - Microsoft Excel documents - Interbase / Firebird - Lotus 1-2-3 - MySQL - Oracle - Paradox - SQL Server - Delimited text files All editions feature target database browser with multiselect which greatly simplifies certain actions. Standard Edition Standard Edition supports (besides conversion itself) dropping of all tables or selected tables/columns. Professional Edition Professional Edition adds a powerful action and parameters handling. Similar tools require that you make mappings from source tables and columns to target, often with cumbersome interface to handle the amount of data displayed. Full Convert makes a swift conversion and puts you in control of target database with additional functionality which enables you to transform database and data structure with ease. Extract several columns to a new table leaving a referencing column, merging data from a table into another, renaming tables and columns and changing their properties, drop unused columns or tables, conditional data changing using your own parameters... Not to mention you can see how many records each table has so you know where your data is. Full Convert remembers all actions and stores them in saved session file. Next time you want to convert, all you have to do is press a button and all your actions are executed after conversion over new data and with no additional work from your side

Full Convert provides you with comfortable way to convert data between many different databases. For highest possible speed and reliability, Full Convert uses native access to databases wherever possible. Currently, native connections are used for Interbase/Firebird, MySQL, Oracle and SQL Server databases. Full Convert 1.0 supports following databases (future version will support even wider variety of data formats) - Microsoft Access - dBase - Microsoft Excel documents - Interbase / Firebird - Lotus 1-2-3 - MySQL - Oracle - Paradox - SQL Server - Delimited text files All editions feature target database browser with multiselect which greatly simplifies certain actions.

Visual Integration Studio is a visual integration design environment for extracting, transforming, and loading (ETL) data from any data source – to any data source using a simple drag and drop, property based interface. Plus, you can code any type of data transformation logic in standard Visual Basic .NET!

SQL Uniform is a database client, graphical user interface (GUI), a helper application to relational databases of various types regarding query, maintenance, data comparison, export (convert), import. It supports any kind of database and database servers to which there is an ODBC or JDBC standard driver. It has been tested on the following databases: Access, Adabas D, DaffodilDB, dBASE, Excel, HSQL, IBM DB2, Interbase (Firebird), JDataStore, Linter (Relex), McKOI, Mimer, MSSQL, MySQL, Openlink Virtuoso, Oracle, Paradox, Pervasive (Btrive), Pointbase, PostgreSQL, Quadcap QED, Solid, SQLITE, Sybase, ThinkSQL, Yard. When starting the program for the first time, you can decide which mode of the program to be used. You can choose between freeware (Lite) and shareware (Professional) mode.

AddressDoctor for Excel is a powerful Add-In for data cleansing. It connects to the world's most complete database of place- and streetnames to correct postal addresses within minutes. You can verify addresses from 240 countries and territories without installing any reference data at your desktop. Up-to-date directories are provided via secured online connections. Efficient algorithms make sure that even incorrectly fielded data is restructured and verified. The trial version allows you to cleanse 250 postal addresses for free.

Spotlight: - database administration and data management - support of data forms - migration from Access to MySQL environment With the product you can administrate MySQL, create data management applications using unique features - forms and logical relationships.

This is a new and powerfull SQL Server tool that enables you to run a search & replace throughout your entire TSQL code - Stored procedures, Functions, and Triggers. In addition, it helps you find the database entities you are looking for, across databases and servers using multiple criteria, and then presents search results in a very intuitive, yet powerful format. A 30 day trial is available for free.

MySQL Service Center is a multi-functional Windows GUI utility for MySQL server maintenance and data reservation. MySQL Server Center allows you to create tasks for backing your data into a script, restoring data from a script, analyzing, checking, repairing and optimizing database tables. In addition to these functions, MySQL Server Center provides you with a powerful task scheduler, ability of using scenarios and other useful features.

MySQL Data Wizard is a powerful Windows GUI utility for managing your MySQL data. It provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. MySQL Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to the MySQL database, export data from MySQL tables and queries to most popular formats, and import data into the tables.

MySQL Maestro is the premier MySQL GUI admin tool for database management, control and development. MySQL Maestro provides you with the ability to perform all the necessary database operations such as creating, editing, copying, extracting and dropping all the database objects includung events, table partitions, views, stored procedures/functions and triggers; moreover, you can build queries visually, execute queries and SQL scripts.

XLReportGen is a report generator for Microsoft Excel that outputs reports in Microsoft Excel spreadsheet format. If you know how to use Microsoft Excel and write SQL statements, you can use XLReportGen to create all kinds of reports as you need. Features: * Using Microsoft Excel as your reporting tool * Making report template directly using Microsoft Excel * Accessing databases using SQL * Creating reports without programming experience * Connection to all databases using ODBC * Supporting multi-databases in one report * Generating reports with parameters * Supporting Windows mode and command line mode * Creating complex reports * Creating reports with pictures * Many reports in one Microsoft Excel workbook * Conversion of file formats * Generating reports automatically * One time configuration * Flexible deployment

WDReportGen is a report generator for Microsoft Word that outputs reports in Microsoft Word document format. If you know how to use Microsoft Word and write SQL statements, you can use WDReportGen to create all kinds of reports as you need. Features: * Using Microsoft Word as your reporting tool * Making report template directly using Microsoft Word * Accessing databases using SQL * Creating reports without programming experience * Connection to all databases using ODBC * Supporting multi-databases in one report * Generating reports with parameters * Supporting Windows mode and command line mode * Creating complex reports * Creating reports with pictures * Many reports in one Microsoft Word document * Conversion of file formats * Generating reports automatically * One time configuration * Flexible deployment

AdventNet SwisSQL offers SQLOne Console, an easy to use Graphical user interface tool to convert SQL queries from one dialect to another. DB Administrators and developers working with multiple databases can just type a query in one SQL dialect and view the equivalent query in different databases’ dialects. It supports Oracle, MS-SQL Server, DB2, Informix, Sybase, MySQL, PostgreSQL and ANSI-SQL SQL dialects.The product is available in both Java and Visual Basic Editions.