Board index   FAQ   Search  
Register  Login
Board index php forum :: Database Other Database Engines

Migration from Oracle to SQL Server

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

Moderators: macek, egami, gesf

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!

Cheers,

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

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.


ie..


function do_sql($string) {
mssql_query($string); // you just change this line when needed..
}
User avatar
egami
php-forum GURU
php-forum GURU
 
Posts: 2197
Joined: Wed Oct 06, 2010 11:19 am
Location: Happy Valley, UT


Return to Other Database Engines

Who is online

Users browsing this forum: No registered users and 3 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.