Yii Framework Forum: ActiveRecord - Oracle x SQL Server - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

ActiveRecord - Oracle x SQL Server Rate Topic: -----

#1 User is offline   EvandroSwk 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 20
  • Joined: 05-May 10

Posted 27 June 2012 - 08:16 AM

I have an application that uses Mysql with ActiveRecord. I'll have to change de database to Oracle or SQL Server.

Which is the easiest to migrate from Mysql?

There are known problems with ActiveRecord and this databases?
0

#2 User is offline   Maciej Li┼╝ewski 

  • Master Member
  • PipPipPipPip
  • Yii
  • Group: Members
  • Posts: 862
  • Joined: 02-July 10
  • Location:Central Poland

Posted 28 June 2012 - 03:00 AM

I do not have any information about MSSQL, but I did use Oracle with Yii:

1. there is no official and supported PDO driver for Oracle. The one existing is in 'experimanetal' stage, quite old and feature-less.. You will have to use some wrapper (PHPPDO) that maps oci8 functions to PDO.
2. there are some issues fetching multiple rows with BLOB/CLOB field and fetching even single row with multiple BLOB/CLOB fields...
3. Oracle itself in my opinion sucks. it is hard to administer, maintain.. had some problems getting support we pay for... pain in the ass :)

there are ways and workarounds to make everything work (we did some projects with Oracle), but it is not as easy as MySQL :)
...and like I said - I do not have experience with MSSQL so it maight be even worse, but can be easier. I think MSSQL and MySQL have come built-in compatibilities (from MySQL side of course :) ) so it might be easier to go this way.
red
0

#3 User is offline   EvandroSwk 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 20
  • Joined: 05-May 10

Posted 28 June 2012 - 09:38 AM

Thank you for answer.

I'll do some tests with SQL Server
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users