CodeIgniter Forums

Full Version: MS SQL SERVER and Oracle DB - Problems?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]tdktank59[/eluser]
So it looks like my application will be switching to sql server and I need to know if there are any issues with sql server...

Im guessing either version 2000 however might be 2005...

Im using php 5 as well.

The other option is oracle... So are there any big issues with these and active record?

Any help would be appreciated.

El Forum

[eluser]kgill[/eluser]
AR won't be the problem, it will be your SQL - neither support limit, instead you have to do a little sql trickery to accomplish it. If you rely on autonumber fields, Oracle doesn't have them instead you use sequences (which in my opinion are much more useful but that's just me). Having worked with both DB's - if I was given the choice I'd pick Oracle.

El Forum

[eluser]tdktank59[/eluser]
Well im also use datamapper which needs autonumbered fields...

But it looks like the limit feature will be the only issue...

El Forum

[eluser]Stallon[/eluser]
Is there a page on the CI userguide illustrating the potential differences between the database drivers?

El Forum

[eluser]tdktank59[/eluser]
[quote author="Stallon" date="1248975588"]Is there a page on the CI userguide illustrating the potential differences between the database drivers?[/quote]

Not to my knowledge..