SQL server 2005 to Oracle Conversion

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts