Tips: Add to Google | Oracle DUL? | AUL License | WebChart | asyncdata | ociuldr

Contact: anysql©yahoo.com/anysql©126.com, MSN: loufangxin©msn.com, AIM: loufangxin

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?...

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...

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...

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...

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...

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...

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...

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....

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...

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...