| URGENT:-Migrating from Oracle to SQL [message #64184] |
Wed, 29 December 2004 01:26  |
Milind Deshpande
Messages: 93
Registered: May 2004
|
Member |
|
|
Hi Experts,
I have a question for you guys.
I have an application designed and implemented on Oracle platform. Now, we are thinking of porting this application to SQL SERVER as per client requirement.
Can anybody give me a detailed description what problems I can face while porting from Oracle to SQLSERVER, I mean the important changes that I have to look for in my application. Do, I have to make any DDL/DML changes and normal select statements to run on SQLSERVER or I can directly run my application on SQL SERVER without any changes in my SELECT/DDL/DML statements.
Pls. give your suggestions for the same.
Thanks in Advance.
Milind.
|
|
|
|
| Re: URGENT:-Migrating from Oracle to SQL [message #64188 is a reply to message #64184] |
Wed, 29 December 2004 20:03  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
I don't know SQL-Server very well, but I do know that one of the major differences with Oracle is its concurrency-model. The way locks are handled differ very much, leading ported Oracle-applications to lock up everything in SQL-Server vice versa.
I don't think you can just port an application from one database to another and expect it all to work.
If you google for the right keywords there are some links that might help you.
Always keep in mind that every sales-related side in a migration will tell you there is 'no problem at all'
Good luck.
hth
BTW, How on earth can this be URGENT? If you really want to rush into this, better forget it!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
