SQL Server database updation from oracle database in realtime
-
I host a website in public domain with ASP.Net and MS Sql Server.I want to update website database as my company oracle ERP databse updated. Is it possible?
Yes using replication or possible triggers...
Never underestimate the power of human stupidity RAH
-
Yes using replication or possible triggers...
Never underestimate the power of human stupidity RAH
-
I dont need whole data in sql server ,i only need some tables. so please tell me how to replicate local oracle database to sql server(hosted in public domain).....
Not my 1 vote but you deserve it. Take a look at the subject of replication, there are books on the subject, your question cannot be answered by a forum post. Triggers spit can be written in the oracle DB that will write the data to SQL Server. You REALLY need to look into your design as this seems to be dramatically flawed.
Never underestimate the power of human stupidity RAH
-
Not my 1 vote but you deserve it. Take a look at the subject of replication, there are books on the subject, your question cannot be answered by a forum post. Triggers spit can be written in the oracle DB that will write the data to SQL Server. You REALLY need to look into your design as this seems to be dramatically flawed.
Never underestimate the power of human stupidity RAH
Ok, My confusion not in replication, Please see the post again. I try to eleborate more, My company using Oracle ERP. Now i have to develop a customer portal in asp.net and sql server that is hosted by any hosting provider. then how I develop database is sql server(some tables of erp database) so that the customer data upadated if erp data upadated in real time. Is it possible?
-
Ok, My confusion not in replication, Please see the post again. I try to eleborate more, My company using Oracle ERP. Now i have to develop a customer portal in asp.net and sql server that is hosted by any hosting provider. then how I develop database is sql server(some tables of erp database) so that the customer data upadated if erp data upadated in real time. Is it possible?
You could develop a small app which can be run as a scheduled task every minute or so which will capture data changed from Oracle and transfer to SQL Server. You will need something on Oracle which will place the data in a temporary storage area (probably a table) eg trigger or addition to stored procedures etc. This could be as simple as creating an insert or update statement etc. This will be captured by the app and executed on SQL Server.