Migration from Oracle to SQL Server

[bainsteven]

Hiya Guys,

I am looking at writing an iPhone App which is required to access data from an Oracle database.

It looks like the easiest way to do it is to access the data via php scripts (running on Apache, possibly?).

However, in the future (maybe a year) the Oracle database is going to be migrated over to SQL Server... so I was wondering if the php scripts will be 'abstracted' enough to simply just change the connection details and continue? (assuming the table names, etc. remain the same).

I am just starting-out down this road - so apologies if I'm barking entirely up the wrong tree!

Cheers,

Steve.

[egami]

You can create your own SQL function or Class, and just change that when you migrate so you don't have to go through your entire scripts and change the function calls.


ie..


function do_sql($string) {
mssql_query($string); // you just change this line when needed..
}