Data Query & Management

EMS SQL Manager 2007 Lite for MySQL provides a graphical interface to manage MySQL Server databases. It supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys etc., and comes with a modern, easy-to-use interface. Other features include visual query builder, user management, advanced data manipulation tools, built-in sql editor and more.

SQLyog MySQL GUI Community Edition is a 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, manage users and permissions, edit table properties and more. The program supports execution of multiple queries and selected (highlighted) or single queries and offers a template explorer to quickly insert commonly used queries, such as create table, insert, drop table, rollback and others. In addition, you can export data in CSV, HTML & XML format and Import from a text file, export data and schema itself, flush hosts/logs and more. The program also allows you to diagnose and optimize your databases, save your favorite SQL scripts in favorite folders and more.

EMS SQL Manager 2008 Lite for SQL Server is a tool for Microsoft SQL Server administration. It allows you to browse and edit table data and procedures, manage database objects, run SQL queries, manage users and more. The program provides a modern, easy-to-use interface; the Lite version is designed for users who are new to MS SQL server and need only it`s basic functionality.

CSVed allows you to manipulate any CSV file, separated with any separator. The contents of the CSV file is visible in a list view window that allows you to easily edit, add, insert, delete and move the items, as if they were in a database table. You can delete rows and add columns or rearrange the column order. In addition, you can remove duplicates and repair files or use the built in search features to find specific records. CSVed also offers search and replace, export to XML and more. If you are frequently working with CSV files, this is an extremely handy tool!

MySQL is the most popular Open Source SQL database on the internet. MySQL is a relational database management system. A relational database stores data in separate tables rather than putting all the data in one big storeroom. This adds speed and flexibility. The tables are linked by defined relations making it possible to combine data from several tables on request. The SQL part of MySQL stands for "Structured Query Language" - the most common standardized language used to access databases. MySQL is very fast, reliable, and easy to use. If that is what you are looking for, you should give it a try.

Microsoft SQL Server 2005 Express Edition (SQL Server Express) is a powerful and reliable data management product that delivers rich features, data protection, and performance for embedded application clients, light Web applications, and local data stores. Designed for easy deployment and rapid prototyping, SQL Server Express is available at no cost, and you are free to redistribute it with applications. Because it is part of the Microsoft Windows Server System, SQL Server Express is designed to integrate seamlessly with your other server infrastructure investments. With a database size limit of 4 gigabytes (GB) and support for 1 CPU and up to 1 GB of RAM, SQL Server 2005 Express Edition is suitable for application embedding or lightweight application development.

DBDesigner is a (open source) visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment. It allows you to manage the database, design tables and more from a visual design interface, as well as manual SQL queries. It also offers features like Reverse engineering of MySQL, Oracle, MSSQL and any other ODBC database, drag and drop of objects, XML database models, model printing and much more. The program provides a very professional interface with detailed documentation available. DBDesigner offers special support for MySQL with support for all MySQL datatypes with all options, but it can also be used with MSSQL, ODBC, Oracle and SQLite.

Ariacom Business Reports is a database reporting and analysis tool with dynamic SQL generation, that enables non-technical users to run and edit complex reports from any SQL relational database. You can create reports by simply selecting tables and fields from your database, and design the report structure by dragging query elements into place. Other features include integrated security management limiting user access, support for Drill navigation, Running totals, Ranking, and Formulas, as well as publication and sharing of reports. The reports can be output to various formats (html, csv, txt, xml with conversion to pdf and doc). The free version is limited to personal usage and offers feature limits for the Report Scheduler and Web Report Server.

HeidiSQL is a graphical interface for easy management of your MySQL server and databases. It allows you to browse your databases, manage tables, view and edit records, manage user-privileges and more. Furthermore, you can import data from text files, run SQL queries, synchronize tables between two databases and export selected tables to other databases or SQL scripts. HeidiSQL offers an easy-to-use interface with syntax highlighting for SQL queries and tabs to switch between database views. Other features include editing of BLOBs and MEMOs, support for large SQL scripts, user process management and more. Open Source.

Exportizer is a tool for viewing, editing, filtering, copying, and exporting of database files (DB, DBF, TXT, CSV, ASC and Lotus files). It supports export to the clipboard or as CSV, TXT, XLS, RTF, XML, HTML or DBF file. You can filter and sort the records, and optionally also combine multiple records into a single line when exporting the data. The program can also be used for simple inline editing and adding of new records. Easy to use compact interface. A Pro version with additional features is also available.

MySQL Administrator is a visual administration tool for MySQL database servers. It provides easy access to many functions like creating tables, editing data, adding records, managing permissions and more. It also include a SQL editor with syntax highlighting to run queries or scripts against the database. Additional features include query history, table analyzer, process list, user management and more. MySQL Control Center eliminates the need for commandline usage and makes server management a lot easier.

WinSQL Lite is a database client that can connect to any database through ODBC. It provides an interface that allows you to run queries, create tables, browse data, edit/insert records and more. The multi-tabbed interface allows you to manage multiple queries and switch between the results. WinSQL Lite also offers syntax highlighting for SQL scripts and can display query results in in grid or a text box. You can even export your results to a template based HTML page using a wizard interface. Additional wizards are offered for Update/Insert and New table. A Pro version is also available that offers some additional features like database specific plug-ins, data export, catalog printing and more. The Lite version however will be perfectly suited for the average users, it can connect to virtually any database that supports generic ODBC connections. The Pro version can connect via ODBC as well as database specific connections.

aespe Table Browser for MS SQL Server provides a simplified way to browse MS SQL database tables without having to use any SQL syntax to sort the columns or to perform basic filtering. The program lists the tables in a Windows Explorer style tree view to the left and selecting one will open the first 100 rows (can be changed). The right click column for each row offers additional copy options that lets you copy the row content in different formats. Additional features include several query helpers to filter the output and search for specific row content as well as an option to run SQL queries.

DbaMgr provides a graphical management interface for MS MSDE 2000 installations. It allows you to manage and administer your server, databases and database objects from a Windows interface similar to the one Enterprise Manager provides, rather than via the standard oSql.exe command line utility. In addition to traditional Sql Server objects management and permissions, DbaMgr adds a visual interface, a query interface, and a visual interface for BCP operation as well as SQL Agent management, providing Alerts, Operators and Jobs management features..

DbaMgr provides a graphical management interface for MS MSDE 1.0 installations. It allows you to manage and administer your server, databases and database objects from a Windows interface similar to the one Enterprise Manager provides, rather than via the standard oSql.exe command line utility. In addition to traditional Sql Server objects management and permissions, DbaMgr adds a visual interface, a query interface, and a visual interface for BCP operation. It also offers SQL Agent management, providing Alerts, Operators and Job management features.

SQLDumper enables you to dump selected SQL Server database tables into SQL INSERT statements , that are saved as local .sql files and contain all the data required to create a duplicate table, or to be used for backup purposes. You can choose to create an individual .sql file for each table, or combine all selected tables into a single file. The program supports foreign keys and IDENTITY keys.

DBF Viewer Plus is a simple viewer and editor for DBF database files. It displays the table content, and allows in-row editing of the data as adding of new record. It also provides a basic search for table content, print support and export to CSV format.

StarInix SQL Compare enables you to compare objects in 2 or more Microsoft SQL server databases. It performs a basic database comparison and returns all items that are absent in any of the compared databases. This includes tables, fields, views, procedures and other database objects. The report can be exported to HTML file.

The Query Tool is a powerful data mining application, designed for the non-technical user. It allows you to perform data analysis upon any OLEDB datasource. The data can be sorted, filtered, printed and exported to a variety of formats. In addition, you can produce charts, summaries and x-tab reports as well as build complex queries, using the built-in Query Builder. No knowledge of SQL is required, all actions are data driven point and click.

SQLTools is a light weighted and robust tool for Oracle database development. It includes a text editor, an SQL console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQLPlus. It is small and does not required an installation.

PostgreSQL for Windows is a SQL compliant, open source object-relational database management system. This is the first PostgreSQL release to natively run on Microsoft Windows as a server. It comes with an adminstration GUI, that allows you to create and manage databases, users and all other aspects of the server administration.

Crystal Report Exporter is a 32bit command line tool that enables user to export your Crystal Reports into PDF, Word(.doc), Excel(.xls), HTML, Rich Text (rtf) or Crystal Report (.rpt) file without having Crystal Report installed. Since it is a command line application, you can use Windows task Scheduler to automate it. In addition, you can export and email the reports as well. No documentation provided with the download, but available from the author`s home page.