Tools for managing databases
From ICISWiki
Database backends > Tools for managing databases
Contents |
Admin GUIs (Freeware)
A new PostgreSQL software appliance: "Turnkey PostgreSQL"
Posted December 9, 2008
...an easy-to-use, lightweight, installable live CD of the PostgreSQL relational database engine that can run on real hardware in addition to most types of virtual machines. It features a Mac OS X-themed Web management interface and a Python configuration and installation console. It is based on Ubuntu 8.04.1 Hardy LTS, and is designed to provide users with a pre-integrated, automatically updated, turn-key operating system environment that is carefully built from the ground up with the minimum components needed to run PostgreSQL with maximum usability, efficiency, and security.
Key features:
- auto-updated daily with latest security patches
- MacOS X themed web management interface
- easy to use configuration console (written from scratch in Python)
- packaged as an installable Live CD that runs on real machines and VMs
- minimal footprint (152MB) - includes only minimum required components
- based on Ubuntu 8.04.1 Hardy LTS
http://www.turnkeylinux.org/appliances/postgresql
AnySQL Maestro
(Released February 12, 2008)
AnySQL Maestro software - a freeware, but powerful tool for all the database engines accessible via ODBC driver or OLE DB provider
- Access
- SQL Server
- Oracle
- MySQL
- PostgreSQL
- etc
http://www.sqlmaestro.com/products/anysql/maestro/
MySQL
SQLyog MySQL GUI - Community Edition (Stable): http://www.webyog.com/en/downloads.php
- has "Import from CSV" functionality
PostgreSQL
pgAdmin III: http://www.pgadmin.org/
Data conversion (Freeware)
eva/3 Universal Database Converter (UDC) v1.2.1
(Posted August 29, 2007)
The Universal Database Converter transfers complete database data structures, data repositories, and indices from one database system to another. Table relationships with primary and foreign keys are also taken into account and transferred into the target system.Thus the Universal Database Converter enables flexible and adaptive handling of various database systems, and also facilitates database migration projects.
Supported database systems: Microsoft® Access®, MySQL®, PostgreSQL, HSQLDB, JDataStore, Microsoft® SQL Server 2000, IBM® DB2 8.1, Sybase® SQL Anywhere 8.0, Oracle®, Parkway Microfocus, SAP® MaxDB®, Ingres® and Firebird
More information here here
Bullzip.com's Access to MySQL Tool
(Posted August 29, 2007)
Convert a Microsoft Access database to MySQL. More information here.
