Guide to Oracle freeware and shareware
Deb Tart, assistant editor
02.15.2005
Rating: -4.43- (out of 5)
|
Can't get something for nothing? We beg to differ!
We've gathered a number of free and low-cost tools and utilities that will help you Oracle DBAs and developers do your job better. Have you come across any other freeware, shareware or inexpensive tools (less than $100) that
I don't have listed here? Shoot
me an email and I'll add it to the library. Don't forget to bookmark this page as it will be updated frequently.
TABLE OF CONTENTS
[IMAGE] Database administration
[IMAGE] Development
[IMAGE] More Oracle learning guides
Database administration
[ Return to Table of Contents ]
Freeware: Adept: Automatically back up most Oracle databases to local storage.
Shareware: ADO Explorer: Connects to any database using ADO and allows you to explore database structure, design scripts and SQL queries, and more.
Shareware: Advanced Query Tool: A fast database query utility and administration toolset that works with any ODBC database.
Shareware: AllDb: Implement any ADO.NET-supported database using a single set of source code.
Shareware: ASP.NET Maker: Create a full set of ASP.NET programs from your data source.
Freeware: Data Loader: Load data directly into an Oracle database.
Shareware: Database Genius: Create and execute SQL queries, format the results to create reports, and export to HTML, TXT, and other file formats.
Shareware: Database Tour: Manage your database with a variety of functions, including viewing, editing, printing, and creating reports.
Shareware: DataXplorer: Browse, edit, and print your database data.
Shareware: DBAny 1.0: Manage your database data with one
To continue reading for free, register below or login
To read more you must become a member of SearchOracle.com
client program rather than many.
Shareware: DBAToolZ: FusionCode (a monitoring solution) and SQL Directory (a script management utility).
Freeware: DBComp: A database comparison and merge application.
Shareware: Database Browser Plus: Updates Web pages with current local database data, exports Word tables to database tables, and more.
Shareware: DBQwikEdit Pro: Connects to any database to edit, move, and export data, generate web pages, create SQL, and more.
Shareware: DBUptime:
Monitor up to four databases simultaneously with this graphical ODBC tool. Receive alert and recovery notices via e-mail.
Shareware: dbXpert for Oracle: Development and administration tool that includes a SQL workspace, object and data browsers, PL/SQL debugger, and more.
Shareware: DTM Data Generator: A customizable, utility that generates data for database testing purposes.
Shareware: DTM Tools: Multipurpose database tools, including SQL editor, schema reporter, data generator, data editor, stress tester, and more.
Freeware: FastOra:
View, compare, modify, and save snapshots of Oracle database structures.
Shareware: Forms Tool Kit: Search and edit your Oracle forms application.
Shareware: GALtoDB 2.0: Copies information from a Microsoft Exchange Server Global Address List (GAL) to a database.
Shareware: GeniusConnect: Synchronize your Microsoft Outlook contact data with any relational database.
Shareware: Granger Unload: A Windows Oracle GUI unloader that can submit unload jobs to background. It can handle Oracle LONGs,LONG RAWs, CLOBs and BLOBs.
Shareware: GUDU Oracle utilities:
EasyScript, EasyDump, EasySQLChecker, Oracle Session Manager, and EasyDBV.
Shareware: Javvin Easy Service Monitor: Keep an eye on your network devices and services, including database servers.
Shareware: JFin: Status monitor for Oracle Financials
Shareware: Material Dreams Oracle utilities: Shared Pool Profiler, Table Exporter, Session Manager, PL/SQL Trace, and Password Changer.
Shareware: ISMAM: Manage your files from any computer that is connected to the Net.
Shareware: Oracle Security Check: Test your user names and passwords.
Shareware: Oracle Session Manager: This tool monitors how connected sessions use database instance resources in real time.
Shareware: OraSnap: A collection of Oracle performance scripts with Web-based output.
Freeware: QuickLoad: Utility to load Excel files to database (MySQL/Oracle) with automatic creation of tables and columns. Supports batch processing of multiple files.
Shareware: RRDORA: A set of UNIX shell scripts for Oracle.
Shareware: RepTool" Light: Generate reports from any type of database.
Freeware: ReportXpert: Acquire different reports for Oracle database performance and statistics.
Freeware: SafetyNet Lite for Oracle: Back up and export your database on a regular basis.
Shareware: Schema graphical editor: A Web-oriented application for editing and analyzing database schemas.
Freeware: SchemaSurf: A browser-based tool for querying your Oracle database schemas.
Freeware: Schemester: Database modeling tool for Oracle: create logical entity relationship diagrams and generate DDL scripts.
Freeware: SqlSpec: SqlSpec generates documentation of the objects in your Oacle, SQL Server or other database. The trial version is free.
Freeware: Statspack Viewer: GUI that helps you visualize Oracle's STATSPACK utility output.
Freeware: SwisSQL:
Helps you migrate Oracle PL/SQL Packages, Procedures, Functions and Triggers to Microsoft SQL Server Transact-SQL.
Freeware: The DDL Extract Wizard: Reads an Oracle export file and displays the DDL code.
Shareware: Universal Table Browser: GUI query tool that gives you access to your database using ODBC connections.
Shareware: VROOM: Cross-platform GUI performance monitor for Oracle databases.
Development
[ Return to Table of Contents ]
Shareware: ADO.NET Express Pro: Add-in for Visual Studio 2003 that generates class methods for calling stored procedures and executing common types of SQL statements.
Freeware: Aqua Data Studio: Create, edit, and execute SQL scripts, as well as browse and visually modify database structures.
Freeware: CAST Code-Checker: Detect and analyze specific performance, portability and
quality issues in the PL/SQL or Java code of your applications.
Shareware: CGIScripter: Write Perl CGI scripts for MySQL, Oracle, Access, and other database servers instantly.
Freeware: CuteSQL: Execute SQL commands and queries for any database.
Shareware: Database Design Studio Lite: Create ERD models, SQL scripts and Java source for forward engineering of relational databases.
Shareware: dbSaint: Build and tune SQL and PL/SQL packages, procedures, triggers, functions, and objects.
Shareware: DBScheduler: Quickly create HTML, ASCII or CSV formatted reports off your databases, and/or schedule them to automatically run at any time.
Shareware: DBSearch: This tool takes away the hassle of finding things in any database, and disregarding structural boundaries. DBSearch finds the string you are looking for in your database.
Shareware: DBScripter for Oracle: A database utility that creates a script from any Oracle database's data, objects and/or source.
Shareware: DBSchemaExplorer:Easily browsing through multiple databases at a time.
Shareware: DBX Commander: A database manipulation, query, and reporting tool. It directly supports all major databases and through the ODBC protocol, many more.
Shareware: ERCreator: An affordable Entity Relationship Diagram tool for ERD data modeling and database design.
Shareware: FlexTracer: Debug program calls to functions located in dynamic-link-libraries —- from Windows API to Oracle Call Interface.
Shareware: FormsMate: Utilities to make developing Forms applications easier and faster.
Freeware: iSQL-Viewer: An open-source JDBC-compliant database front-end written in Java, including a query builder, object viewer, batch processor and more.
Freeware: JBSQL: Enhanced SQL*Plus editor with improved output, text editing, and command history.
Freeware: JDBExplorer: Create, view, edit, and compile PL/SQL and Java code.
Shareware: JSPMaker: Create a full set of JavaServer Pages directly from MySQL or Oracle.
Shareware: IAB Studio: Develop and deploy J2EE-based Internet applications.
Shareware: Lattice.SPGen: Develop database-stored procedures for Oracle and SQL Server.
Shareware: Multiple Database Query Analyzer: Run queries in SQL Server, Access, Oracle, and MySQL databases.
Freeware:MyGeneration: Generate C# and VB.Net classes and stored procedures from customizable templates.
Shareware: Oracle Data Access for C++ Builder: Provide your applications with a direct access to Oracle databases.
Shareware: Oracle Data Access Components for Delphi: Access Oracle RDBMS with these Delphi components.
Shareware: OraDirect .NET Data Provider: Access an Oracle database server for the Microsoft .NET Framework.
Freeware: OracleTool: Edit, modify, create and drop all types of objects; compare schemas and data; PL/SQL editor.
Freeware:OraEdit: Edit and compile your PL/SQL code, create new objects from templates, export all/some source, and more.
Shareware: OraPowerTools: OraEdit (a PL/SQL development environment), DBDiff (compare and upgrade any two Oracle databases), and DBScripter (create SQL scripts from Oracle objects or data).
Freeware: Query Reporter: Create and run HTML reports from the results of a SQL query against an Oracle database.
Shareware: QueryToDoc: Document your Oracle database by translating its schemas into an easy-to-read Microsoft Word document.
Shareware: SDE for JDeveloper :
A UML CASE tool/plug-in that allows you to draw all types of UML diagrams,
generate Java code, reverse engineer Java code to class diagrams and generate documentation.
Shareware: SQLConsole: A visual query builder, with SQL authoring, connection manager, intelligent auto-complete or keywords and context sensitive editing.
Freeware: Statement Tracer for Oracle: Tool for debugging programs interfacing with Oracle.
Freeware: SQLCreator: A Java-based graphical SQL database query and development tool.
Shareware: SqlFree: Build SQL statements visually with this program.
Shareware: SQL Query Tool (ODBC): Query ODBC data sources, author SQL scripts, and retrieve ODBC driver information.
Shareware: SQL Script Builder: Create SQL scripts from any ODBC data source.
Shareware: SQL Tools: PL/SQL editor, compiler, and object viewer.
Shareware: SQL*XL: Bridge between Excel and Oracle databases.
Freeware: TOAD: Toad improves productivity with all the functionality needed to build and execute queries, create and modify database objects, and develop and debug SQL and PL/SQL code.
Freeware: TranslateSQL: Generates SQL Server SQL scripts based on an existing Oracle schema, in essence 'translating' Oracle schemas into SQL Server databases.
Freeware: TSHSQL: A Java-based PL/SQL editor and SQL query tool.
Shareware: Universal SQL Query Tool: Build queries to connect and manage virtually any database via ODBC.
Shareware: WebExpress: Create Web sites, Web pages and design database-driven Web forms without programming or editing HTML.
Shareware: <XSLmaker>: Add, delete, edit, view, and search data in a database on the Web and create dynamic, XML/XSLT-based Web sites.
More Oracle learning guides
[ Return to Table of Contents ]
Crash Course: Oracle basics: This guide helps you to research, compare or work with the Oracle DBMS. It provides Oracle basics for versions 8.x, 9.x and 10g.
Learning guide to Oracle error messages: Solve your Oracle errors quickly and easily with help from this fast guide. It covers every expert response pertaining to Oracle errors on SearchOracle.com.
Learning Guide -- Performance tuning: Newbies and experts will benefit from this guide; you'll establish a smart approach to tuning, use and interpret Oracle's tuning utilities and identify specific problem areas.
Learning guide to PL/SQL: This fast guide to PL/SQL can help both newbies and veterans become better acquainted with the language and hone their developer skills.
Learning guide: Oracle security: This guide covers a wide variety of topics on many aspects of Oracle security to help you lock down your data.
Fast Guide: Becoming an Oracle Certified Professional: Get expert technical advice on where to begin your certification studies, passing the final exam and putting your certification into effect in the workplace.
|
|
|
|
|
|
