Database Tools

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.

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.

Advanced Access Repair (AAR) is a powerful Access recovery tool. It will scan the corrupt or damaged Access databases and recover your data in them as much as possible, so to minimize the loss in file corruption. Currently AAR supports to recover Microsoft Access 95,97,2000,XP,2003 databases. Moreover, it is integrated with Windows Explorer, supports drag & drop operations, which will make you repair Access databases easily and quickly.

The FileMaker 7 AppleScript Reference document provides a quick reference guide to commonly used FileMaker 7 AppleScript commands. This document provides a description of each code example, the FileMaker 6 example code, and the FileMaker 7 example code. The FileMaker 7 version of this document enables developers to copy and paste example code directly from each field of the database.

DBSP (Data Base Scripting Pages) is a new server-side scripting technology designed specifically for the exploitation of databases across the Internet. The strongest quality of DBSP is time spent in development cycle. With DBSP you could deliver complex database oriented Web solutions in weeks. DBSP allows you to focus in solving your customer needs instead of wasting your time in solving technical issues.

Whether you are a PHP, Perl or Python Developer or simply have a message Board, Guestbook or other MySQL application running on your web server, this application will allow you to quickly and efficiently search through large MySQL tables and find the stuff you're looking for directly in your Web Browser. You can View, search and sort through tables in any MySQL database, Store views, ignore columns and more.

Advanced DBF Repair (ADR) is a powerful tool to repair corrupt DBF files. It can scan the corrupt DBF files and recover your data in them as much as possible, so to minimize the loss in file corruption. Currently ADR supports to fix dBASE, FoxBase, FoxPro and Visual FoxPro database. Moreover, it has integrated with Windows shell, supported drag & drop operations and command line parameters, which will make you repair DBF files easily and quickly.

Easy-to-use database reporting and multi-dimensional analysis tool with dynamic SQL generation. Native line, bar, point and pie charts. Integrated security management limiting user access. Report results in various formats (html, csv, xml, pdf, rtf). Output to file,email,ftp. Reports ready to use for sugarCRM, vtiger CRM. COM Component to be integrated into any Win32 applications.

Sync Database is easy solution to synchronize schema of mySQL databases. When you alter database, add or change columns, indices or constraints, sync is done in an quick and painless process and enables you to change the structure of your older database to its newest version while preserving its data. 1. Select source database or load an SQL script. 2. Select target database (you can also create it using builtin script editor) 3. Synchronize!