migration from sql server to oralce database

Last post 05-08-2008 11:37 PM by shivarlakrishna. 2 replies.

Sort Posts:

  • migration from sql server to oralce database

    05-08-2008, 2:52 AM

    I had project which is developed in .net 1.1 and back end is sql server database. Here I want to migrate this project to .net 2.0 and back end as Oracle.My project architecture is 3 tier(DAL,BLL,UI). For this project what are the changes I need to make in these 3 layers, so that easily this project can migrate to .net 2. and Oracle as back end.And please tell me what are the enterprise libraries I need to use for .net 2.0 for connecting to oracle database. 

     

    Thank You,

  • Re: migration from sql server to oralce database

    05-08-2008, 8:19 AM
    Answer

    Well If you have really managed your n-tier architecture in the way it should be then you need not to worry a lot. You have to change -

    1) Connection string and connection related settings in Web.Config

    2) You have to include oracle data providers instead to SqlHelper or SqlClient.

    3) You need to change your database interacting classes for oracle interaction.

    BLL and UI will remain the same. 

    Better you use -

    1) Oracle data provider for .net

    2) Ms Enterprise library 3.1 

    Hope it helps. 

     

    Hope it helps.

    -Manas

    =======================================
    If this post is useful to you, please mark it as answer.
  • Re: migration from sql server to oralce database

    05-08-2008, 11:37 PM
    Answer

    Thank You for resolving my problem.

Page 1 of 1 (3 items)
Microsoft Communities
Page view counter