Migrating from ? to Oracle

From: Wiliam Stephens (wil_at_fbagroup.co.uk)
Date: 02/05/04 

To: dbi-users@perl.org
Date: Thu, 5 Feb 2004 17:25:44 +0000

Hi

I'm going to be working on a Perl app using a database through the DBD
set of drivers. The end production machine will run Oracle for which
there is already DBD::Oracle.

However, we don't have access to Oracle locally and wish to use a
replacement for the bulk of the development process before moving over
to the production servers.

Because both databases can be accessed using the DBI divers then it
would seem logical that the same application, if coded correctly, could
be used with a number of databases without changing much, if any, of
the code. This is the theory I'm working with.

However, I know in reality that small changes to SQL syntax will have
to be made.

What I'm basically asking is, what is the best database to use as a
development database before migrating over to Oracle? Is MySQL the most
similar in terms of syntax? Or can I stick with my preferred choice of
Postgresql? Are there any big gotchas to watch out for switching
between both databases or if I stick to fairly standard SQL syntax and
functions I should be OK. If there is a list of differences between the
functions of the various DBI drivers that would be great.

Thanks for your help.

Wil 

--
Wiliam Stephens
FBA MEDIA
Tel: 01970 636412
Mob: 07968 325637
http://www.fbagroup.co.uk/

Relevant Pages

  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)
  • A cool DBA job wanted
    ... 7, Oracle 6, Sybase, SQL Server ... Proposed proactive database monitoring through ... strategies to administer remote Oracle databases ... Trained installation and support personnel in basic ...
    (comp.databases.oracle.server)
  • Re: I want to add to myknowledge
    ... 7, Oracle 6, Sybase, SQL Server ... Oracle Database Administrator ... Trained installation and support personnel in basic ... Senior Oracle Database Administrator ...
    (comp.databases.oracle.server)
  • Re: choices regarding where to place code - in the database or middle tier
    ... Before Oracle decided to allow you to write stored procedures in Java, ... Even without Java existing, let alone being hosted in the database, you ... of languages that they developed for the middle tier, ... the .NET developers out there will be faced with this choice. ...
    (comp.lang.java.databases)
  • Re: choices regarding where to place code - in the database or middle tier
    ... Before Oracle decided to allow you to write stored procedures in Java, ... Even without Java existing, let alone being hosted in the database, you ... of languages that they developed for the middle tier, ... the .NET developers out there will be faced with this choice. ...
    (comp.lang.java.programmer)