Looking at this question 10000 ft above, I would look after the connection string, the database provider(sqlclient/oledb,etc) and other APIs which are involved in interaction with the database.
Regards | Sudeep Kshirsagar | MCPD (ASP.Net) | MCTS(WCF) | My Blog Please mark the post as "Answer" if it helps you.
saffy
Member
304 Points
365 Posts
Change database from MsSQL to Oracle
Dec 05, 2011 09:08 AM|LINK
Hi,
We are doveloping our application using MS SQL Server,
when it go to live it need to be on ORACLE
Can you please suggest what are the precautions need to be taken while development.
sudeep_13
Contributor
2549 Points
512 Posts
Re: Change database from MsSQL to Oracle
Dec 05, 2011 11:50 AM|LINK
Hi,
Looking at this question 10000 ft above, I would look after the connection string, the database provider(sqlclient/oledb,etc) and other APIs which are involved in interaction with the database.
Please mark the post as "Answer" if it helps you.
gopalanmani
Star
7826 Points
1320 Posts
Re: Change database from MsSQL to Oracle
Dec 05, 2011 01:23 PM|LINK
Hi,
No easy way. But Don't forget use Tier architecture. See the below link for Provider Independent Data Access Layer
http://www.dotnetbips.com/articles/fbea3517-b0c8-4e79-bc52-cc75e0b1b86f.aspx
http://www.codeproject.com/KB/database/data_access_layer.aspx
http://www.aspnet101.com/2010/05/implementing-a-generic-data-access-layer-in-ado-net-part-1/
This will help you in future
Gopalan Mani
My Tech blog