Free oracle database administration software for windows

Navicat for Oracle offers powerful visual tools such as Query Editor with syntax highlight capability, SQL Preview, SQL Console, TEXT, Hex and BLOB viewer/editor, SSH Tunnel and more, to increase your productivity. Also, it provides a number of tools allowing to perform all the necessary database operations such as creating, editing, and duplicating database objects. It also offers a well-described wizard system that simplifies your database development tasks.
Navicat for Oracle full version includes more powerful features such as Data/Structure Synchronization, Import/Export, Backup, Report, task scheduling, code completion, etc. Together with comprehensive and instant support services, Navicat Oracle makes database and application development faster and easier while simplifying day-to-day administration tasks.
It also includes a full featured graphical manager for setting the users and access privileges. Navicat is being used by Google, Yahoo, AOL, Intel and EBay, etc.
Navicat for Oracle can connect to any Oracle Database version 9i and later and runs on Windows and Mac OS X. Navicat is also avaliabe for MySQL and PostgreSQL.

A free program that allows small and medium sized shops running Oracle on Windows based servers to automate the process of regularly backing up and exporting data from their database to external files. These files can then be backed up and stored on other media, allowing the company to recover the complete database or individual tables in case of disaster. The program expires every 60 days but is completely free. The backup schedule, location where the files are stored and other information is completely configurable. A shareware version of the SafetyNet program also supports data replication to an Oracle Standby server, automatic notifications when database errors occur, purging of archive log files and other features.

Requirements: Oracle Database running on Windows server

Whats new in this version: Second public version: no longer exipres after 60 days

DatAdmin Personal 3.0.5 is just a perfect choice for easily and quickly administrating database. It natively supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access. Also it can be used to create and restore backups, transfer data between databases, tables or files (supported formats are XML, CSV, HTML, Excel), edit database schema.

Major Features:

1. Connect to database
   • Connect using ADO.NET native drivers. Distributed with native ADO.NET drivers for MySQL, PostgreSQL, Sqlite. Native drivers for MS SQL are distributed with .NET.
   • Function Driver manager, which allows using other ADO.NET drivers
   • Connection over generic database interfaces OLE DB and ODBC
   • Function PHP tunnel, which allows connection to MySQL databaases on webhosts server, which dosn't offer direct access to database server
2. Database management
   • Creating and editing tables (CREATE, ALTER TABLE), database specific table properties (MySQL engine, collation)
   • Comfortable foreign key management, UPDATE/DELETE rules
   • CHECK, UNIQUE constraints, indexes
   • Database object management - triggers, functions, stored procedures, views, schemata
   • Generating SQL scripts for different object types - CREATE, DROP
   • MySQL objects: triggers, functions, stored procedures, views, events
   • MS SQL objects: triggers, functions, stored procedures, views
   • SQLite objects: triggers, views
3. View and edit data
   • Viewing and editing data in table
   • Quick fulltext search
   • Filtering rows - fulltext search or SQL conditions
   • Sorting rows by clicking on column header, sorting by more columns
   • Lookups (preview of destination foreign key row), selecting rows from validation tables
   • Automatic master/detail views created from foreign keys
   • Forward/Back function for browsing master/detail views history
4. Backup, export, import
   • Backup database as "Data archive" - ZIP file - platform and database independent backup
   • Ability to use native backuping tools (mysqldump, pg_dump)
   • Restore from backup, restore whole database or selected tables (selecting tables is possible only when using data archive as backup format)
   • Export of table data to formats CSV, TXT, HTML, XML, SQL, Excel
   • Import of table from formats CSV, XML
   • Export database structure into formats HTML, WIKI
   • Copy database/table to another server using drag & drop
   • Any data operation can be saved as job and executed later, also from command line
   • Scheduling using Windows Scheduler Service (applicable to any type of job)
5. Database design
   • Editing of database model. Model can be generic or database specific
   • Definition of tables, keys, constraints
   • Definition of all object types in database model
   • Database diagrams, stored in connection (locally or in database)
   • Comparing & synchronize structure of model, real database or data archive (database backup)
   • Migration of model to different dialect
   • Generating CREATE/DROP scripts in any of supported dialect
   • Reverse engineering - loading model from existing database
6. SQL Editor
   • SQL Editor with syntax highlighting
   • Advanced search & replace
   • SavingSQL query to connection - locally or in database
   • Viewing more result sets from one query
   • Graphical query designer, with drag & dropping tables from connection tree, tables could be joined (LEFT/RIGHT/INNER/OUTER JOIN), sorting, filtering, grouping

Requirements:

• Windows 2000 Service Pack 3; Windows 98; Windows 98 Second Edition; Windows ME; Windows Server 2003; Windows XP Service Pack 2, Windows Vista. Since DatAdmin 3.1 both 32-bit and 64-bit versions are fully supported.
• Microsoft .NET framework 2.0