Helping PHP developers migrate from MySQL to Oracle
We’ve almost made it through the first day of the PHP conference in Germany. The conference is well organised and a smashing success. Thanks to everyone who has stopped by the booth and said hello!
We’ve noted some points that people are generally surprised to learn when talking to us:
Oracle XE is free to develop on, […]
My previous article on implementing incremental RMAN backups on XE had some problems:
I failed to set a recovery window so that RMAN could accurately determine which backups were okay to delete
I referred to my tag as whole_db_cpy in my copy and whole_db_copy in my incremental backup
This combination led to a very small database taking up […]
Oracle as such does not have an auto increment field type. You can however emulate the auto increment field type using a trigger and you can also retrieve the auto incremented value back from an insert statement. This article will show you all you need to emulate auto increment type fields in Oracle.
One of the primary reasons for choosing Oracle over MySQL is Oracle’s rich set of enterprise features. This article looks at the builtin backup features of Oracle provided by the Recovery Manager (RMAN).
Since we are migrating from MySQL to Oracle, let’s compare RMAN to MySQL’s backup offerings. The two main programs for backing up […]
One of the most frustrating things about being a small company in 1999 was not having a decent database at an affordable price. Oracle and DB2 were too expensive so we were left with MySQL and PostgreSQL. Postgres was reliable in those days but rather slow. MySQL was extremely fast but left out some basic […]
