SQL server 2005 to Oracle Conversion

Posted by Vinokanna under Sql Server on 2/11/2015 | Points: 10 | Views : 545 | Status : [Member] | Replies : 1
Hi,

Our client Use - Frame Work 4.0, Visual Studio 2010 developed application Back end As SQL Server 2005 .

We are not using Oracle.

Now they planned to change Oracle (I don't know What version).

What are the steps to be used,

1) How Web.config file to connect oracle DB.

2) How to Convert SQL tables ,Views and Stored procedure to Oracle.

3) How to make it same package as they used in SQL DB.


Please Share Your Experience.
Vinoth




Responses

Posted by: Bandi on: 2/11/2015 [Member] [MVP] Platinum | Points: 25

Up
0
Down
1) How Web.config file to connect oracle DB.
To make Oracle Connection, web.config file should be as follows
http://stackoverflow.com/questions/16432576/oracle-database-connection-in-web-config-asp-net

2) How to Convert SQL tables ,Views and Stored procedure to Oracle.

It depends on your code/logic.

refer this link for SQL server and Oracle differences in high level
http://db-engines.com/en/system/Microsoft+SQL+Server%3BMySQL%3BOracle


Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Vinokanna, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response