Home » RDBMS Server » Server Administration » URGENT:-Migrating from Oracle to SQL
- URGENT:-Migrating from Oracle to SQL [message #64184] Wed, 29 December 2004 01:26 Go to next message
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.

Report message to a moderator

- Re: URGENT:-Migrating from Oracle to SQL [message #64188 is a reply to message #64184] Wed, 29 December 2004 20:03 Go to previous messageGo to next message
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!

Report message to a moderator

- Re: URGENT:-Migrating from Oracle to SQL [message #64189 is a reply to message #64188] Wed, 29 December 2004 20:22 Go to previous message
Milind Deshpande
Messages: 93
Registered: May 2004
Member
Thanks a lot Frank.

Regards

Milind.

Report message to a moderator

Previous Topic: display error again pls hlp urgent
Next Topic: Multiplexing of Archuved redo log?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 04 18:43:38 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.