DBA Tools

Trigger based data replication utility from Oracle to MySQL database

    In some read focus system, we may make copies of the write database to take the heavy read activites, however how to make a read database if we plan to write on Oracle and read from MySQL database?...

Posted on April 10, 2011 12:27 PM

Migrate Oracle data to MySQL database with ora2mysql utility

    I wrote a program named (ora2mysql) when learning MySQL C API client programing, it can be used for data migration from Oracle to MySQL database, and I think it's definatelly a good utility for DBAs who need manages...

Posted on April 8, 2011 3:41 PM

Define the row filters for reports in WebChart

    Supposed that we are creating a report of the top 3 highest salary employees for every department (check the Oracle demo table : SCOTT.EMP). If the table is stored in Oracle database, we could generate the report with...

Posted on March 4, 2010 10:42 PM

Define different SQLs for different databases in WebChart

    Some people like to run WebChart demo application on Oracle database, while some other people may like to run WebChart demo application on MySQL database. Seems I have to write two WebChart demo applications, one for Oracle, another...

Posted on March 3, 2010 5:01 PM

The logical database layer and physical database layer

    Usually our application are bound to one physical database, for example, we always read our data from specific Oracle database or MySQL database, or write business data to specific Oracle database or MySQL database. The physical database is...

Posted on January 27, 2010 6:14 PM

Migrate data from Oracle to MySQL with SQLULDR2

    More and more people are moving non-important data out of Oracle to MySQL for lower Oracle license fee. For DBAs, we need to know how to migrate data from Oracle to MySQL quickly. I will introduce you how...

Posted on October 29, 2009 11:55 PM

Copy data between different databases with copydata script

    We start to introduce MySQL and PostgreSQL into our business system, as a replacement of Oracle, to save the license cost. First we need to move some data from Oracle to MySQL or PostgreSQL for performance testing or...

Posted on June 10, 2009 9:32 PM

WebChart Sample Pages on MySQL Database

    With Java JDBC technology, WebChart can connect to many different types of database system, such as MySQL. Now I will show you some examples pages on MySQL. First, create the demo table with the following script in MySQL....

Posted on March 21, 2009 1:27 AM

What AnySQL learned from MySQL?

    When I start to learn MySQL database, I feel Oracle SQL*Plus should learn from MySQL to display the result as form style. It's not implemented in Oracle 11g's SQL*Plus, but you are still lucky because I implement it...

Posted on December 20, 2007 10:00 PM

Got the "Table is full" error for MySQL memory engine table

    After using MySQL memory engine table as middle cache table, we got this error when application inserting the data to the table. Seems there is some limits on the table. After searching on Google, we know that we...

Posted on September 25, 2007 7:46 PM