Database Tools

Excel Add-in that allows you to query any ODBC Data Source from inside Excel. This add-in creates a new function that allows you to directly query any ODBC data source on the machine and displays the results in Excel.

Ms Access database to MySQL database migration application tool accurately converts source database into MySQL database. Software utility converts data table as well as structures of database. Application program also transfer keys constraints and indexes values of data tables. Software converts whole database as well as only selected tables at a time. Software tool imports structures and data of database tables of large database and converts into MySQL database format with supporting database integrity. Software utility supports Unicode architecture. Tool supports mixed or windows mode of authentication of database systems. Software utility has data-conversions rich wizard interface for conversion of database. Software efficiently runs under Windows 98, Windows ME, Windows 2000, Windows NT, Windows 2003 Server, Windows XP, Windows VISTA operating system

Export Query to SQL for Microsoft SQL Server helps to save results of a query execution as a set of INSERT SQL statements. Predefined or cusrtom separators like 'go', two identity support modes and a few options make this tool flexible. The program has easy to learn and to use wizard interface. This handy utility helps database developers and database administrators to create query-based SQL script within seconds.

Export Query for Oracle Server helps to save results of a query execution to Excel spreadsheet. The program supports has a few settings to make export more flexible. Export Query utility has easy to learn and to use wizard interface. All modern versions of Oracle Server and MS Excel are supported. This handy utility helps database users to create text file for database query within seconds.

This copy tool for Microsoft SQL server creates a copy for database objects definition: tables, views, triggers, indexes, primary and foreign keys, procedures, etc at the different database on the same or another server. The program has easy to learn and to use wizard interface. This handy utility helps database developers and administrators to create copy for any Microsoft SQL server database schema (metadata) within seconds.

Navicat Lite is an intuitive GUI tool lets you create, browse databases, run SQL queries and connect to remote MySQL, SQL Server, SQLite, Oracle and PostgreSQL in an easier way. 30 days demo version includes query builder, report builder, backups/ restore, batch job scheduling, and the ability to convert Access to MySQL, SQLite, SQL Server, Oracle and PostgreSQL and Excel to MySQL, SQLite, SQL Server, Oracle and PostgreSQL. Other features include a SQL Console, View Builder and Data Synchronization.

DTM Data Generator is a simple, powerful and fully customizable utility that generates data for database testing purposes. Currently, database developers and DBAs often have to spend hours of work to create test data before examining database performance. This tool makes all this unnecessary by automatically creating test data, database tables and sets of Insert/Update statements. The tool resolves foreign keys and order of tables automatically.

Export Query to Excel for Microsoft SQL Server helps to save results of a query execution to Microsoft Excel spreadsheet. The program has easy to use wizard interface. All modern versions of Microsoft SQL Server and all versions of Microsoft Excel are supported. A few options make export process more flexible and comfortable to use. This handy utility helps database users create Excel spreadsheet for selected table within seconds.

Export Table to SQL for Microsoft SQL Server helps to save table's data as a set of INSERT SQL statements and optional CREATE TABLE statement. Predefined or cusrtom separators like 'go', two identity support modes and a few options make this tool flexible. The program has easy to learn and to use wizard interface. This handy utility helps database developers and database administrators to create table-based SQL script within seconds.

Export Table to SQL script for db2 helps the user to save table's data as a set of INSERT SQL statements and optional CREATE TABLE statement. Predefined or custom separators like ';' and a few export options make this tool flexible. The program has easy to learn and to use wizard interface. This handy utility helps database developers and database administrators to create table-based SQL script within seconds. All Oracle versions are supported.

Export Table to SQL script for Oracle helps to save table's data as a set of INSERT SQL statements and optional CREATE TABLE statement. Predefined or custom separators like ';' and a few export options make this tool flexible. The program has easy to learn and to use wizard interface. This handy utility helps database developers and database administrators to create table-based SQL script within seconds. All Oracle versions are supported.

DTM Schema Comparer is a visual database schemas comparison and synchronization tool that supports ODBC, OLEDB, IDAPI and Oracle Call Interface connections. The visual representation of database schemas as a tree makes the comparison process more comfortable. The tool deals with tables, views, indexes, keys, triggers, procedures. The built-in SQL text comparison tool allows you to view two scripts with differences displayed in a comfortable way.

Import your MySQL databases into MS Access format. Great for accessing your data off line. Use MS Office to analyze and report on your data. Create off-line backups, in usable relational form. Easy to use, connects directly or imports MySQL dumps. You can import just the tables you need, or just the table structures. The program handles all the complexities of data conversions, indexes and identifiers. No SQL required, super simple.

DTM Data Modeler is a CASE tool for database developers that supports both forward and reverse engineering. It is an easy-to-use tool allowing you to work both with logical and physical data models in the form of an entity-relationship (IDEF1X) diagram. The product is intended for database architects and developers and works with data sources via the ODBC, OLE DB, IDAPI or Oracle Call Interface, which means compatibility with all modern DBMS.

DTM DB Stress is a utility for stress testing the server parts of information systems and database applications, as well as DBMSs and servers themselves. This tool allows you to create and configure a continuous set of requests to the server of the OLAP (query execution) and OLTP (adding, modifying and deleting data) types. The program is useful for any information system developer or any QA department employee.

DTM Data Comparer is a visual tool to data compare and synchronize. The program successively views the contents of both tables basing on the order of ascending of unique key values and shows differences or creates synchronization script. If Comparer cannot find two records with the same key value, it places the records to different lines and highlights in yellow. Otherwise, the program places them to same lines and highlights differences.

This shell script backs up any or all of your databases and emails and/or FTPs them over to you. You can send the backups to unlimited email addresses and to unlimited FTP servers. The script is very flexible, so give it a try! With cron, you can have this process automated, leaving you with regular backups, as well as a piece of mind.

DBFView - the most popular DBF editor and viewer for Win9x/NT/2000/XP in the world! DBFView is a compact but powerful tool for viewing, editing, and printing DBF-format databases. It supports dBase, Clipper, FoxPro, Visual FoxPro and other DBF formats. In contrast to many analogues, DBFView is completely a Windows9x/NT/2000/XP program. The user friendly graphic makes working with databases simple. Most important parts of DBFView code are written in Assembler, therefore the basic operations performs fast and the .exe file is very small. DBFView uses its own database access tools and does not require external drivers for connection to databases (such as ODBC or BDE) or additional libraries (.OCX, .DLL). The program allows you to add, delete, recall, sort, zap, pack records, view and edit files in DOS or Windows character sets, get detailed database information, export to txt/html/csv/xls/xlsx format, and search in a file. DBFView comes with Installer/Uninstaller, documentation in HTML.

A collection of 10 tutorials for you to get started quickly with running Transact-SQL statements on SQL Server 2005. Clear examples are provided for running CREATE TABLE, INSERT, UPDATE, DELTE, SELECT, CREATE USER, GRANT EXECUTE statements.

GalaXQL is an interactive SQL tutorial. Follow the instructions by your virtual teacher. The teacher can understand several possible mistakes that you may make, and gives hints on what may have gone wrong. You can skip to any chapter in the tutorial whenever you want. Use the query editor to interact with the database, and to complete the assignments given by the virtual teacher.