Migration from Oracle to SQL Server

Do you have questions regarding other database enginges (not MySQL) -- ask here!

Moderators: macek, egami, gesf

New php-forum User
New php-forum User
Posts: 1
Joined: Tue Apr 24, 2012 11:55 pm

Migration from Oracle to SQL Server

Postby bainsteven » Wed Apr 25, 2012 12:04 am

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!



User avatar
php-forum GURU
php-forum GURU
Posts: 2196
Joined: Wed Oct 06, 2010 11:19 am
Location: Happy Valley, UT

Re: Migration from Oracle to SQL Server

Postby egami » Wed Apr 25, 2012 4:22 am

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.


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

Return to “Other Database Engines”

Who is online

Users browsing this forum: No registered users and 4 guests