Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dennislaymi
Starting Member
2 Posts |
 Posted - 2011-06-02 : 10:50:26
|
| Hello guys,I'm working in a project written in PHP/JAVA which uses SQL as DB for now but will be migrated to ORACLE pretty soon. So the idea is to write this version of the project using SQL but compatible with ORACLE so we could migrate DBs in a near future.We've started using MySql then we moved to SQL and now we would like to create a version using SQL but ready for ORACLE.I have never done it before so I'm a bit confused of what path should I take regarding to the query statements.Any suggestions are welcome!Thanks for you time!Dennis |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-02 : 11:00:25
|
| Update statements are quite different in oracle.Also look at the equivalent of identity.In general anything that deals with large datasets or needs to be efficient will be coded very differently in the two systems.Get a test system and see what works - the first issue will be the connection and permissions.I did work on a system which had a requirement that the database interaction should work against any database (where any was a restricted list) - which meant restricting to odbc calls and very basic sql.p.s. this is nothing to do with scaling.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
dennislaymi
Starting Member
2 Posts |
Posted - 2011-06-02 : 11:21:12
|
| Thanks nigelrivett!I had a look on something called OQL, do you think that would help me any how?Sorry about the Scaling word :D that is another issue which Im dealing with at the same time so I got my thoughts mixed up.Thanks again for your help!Dennis |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Getting ready for a migration from SQL to ORACLE