I need your help to solve a problem.
-
Problem: I developed a website with ASP.Net and SQL Server.All data I am accessing from SQL Server. This site will hosted in public domain as internet website and it is a kind of CRM portal.My Sql server datbase has 11 tables. My company uses Oracle ERP.Now I want to update data from oracle erp to SQL Server.I have created views in Oracle as data needed in SQL Server. Means when a customer created/information updated ,it should be updated in SQL Server database. Is there any solution? I tried google but there is no suitable answers. Please reply me.
-
Problem: I developed a website with ASP.Net and SQL Server.All data I am accessing from SQL Server. This site will hosted in public domain as internet website and it is a kind of CRM portal.My Sql server datbase has 11 tables. My company uses Oracle ERP.Now I want to update data from oracle erp to SQL Server.I have created views in Oracle as data needed in SQL Server. Means when a customer created/information updated ,it should be updated in SQL Server database. Is there any solution? I tried google but there is no suitable answers. Please reply me.
Uma Shankar Patel wrote:
I tried google but there is no suitable answers. Please reply me.
Google for "linked server Sql"; it's a few Sql-statements, allow you to access the Oracle-tables as if they were on Sql Server.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
Uma Shankar Patel wrote:
I tried google but there is no suitable answers. Please reply me.
Google for "linked server Sql"; it's a few Sql-statements, allow you to access the Oracle-tables as if they were on Sql Server.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
Yes I tried this, but how can i update my database in SQL server in real time means when I update data in oracle ERP it should be updated in SQL Server. and does Hosting provide provides Linked server facility?
-
Yes I tried this, but how can i update my database in SQL server in real time means when I update data in oracle ERP it should be updated in SQL Server. and does Hosting provide provides Linked server facility?
I doubt very much that a hosting provider will allow you to configure a linked server; this needs to be done by a system administrator of the SQL Server. You should email the tech support folks at your hosting provider and ask them directly. An alternate solution would be to create a webservice on your hosted site which would process datachanges from your Oracle system. You could create a folder somwwhere on your server and write an XML file which represents the data change, then have a Windows service monitor that folder for new files and when it sees one, call the webservice to update the SQL database. It is not a real-time solution, but it would be pretty close. Good luck. :thumbsup:
-
Yes I tried this, but how can i update my database in SQL server in real time means when I update data in oracle ERP it should be updated in SQL Server. and does Hosting provide provides Linked server facility?
Uma Shankar Patel wrote:
Yes I tried this,
If you did, than why did you not mention that with your question? What else did you try?
Uma Shankar Patel wrote:
does Hosting provide provides Linked server facility?
No. It's something that's built in to Sql Server, and it requires a database-connection to the remote database-server. The remote host will not allow remote connections, to prevent people from abusing them as a cheap alternative for databases. You could fetch the latest info from the remote host itself; generate Xml using PHP locally on the MySql machine, read it from your code by fetching the webpage, and updating your database.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
Yes I tried this, but how can i update my database in SQL server in real time means when I update data in oracle ERP it should be updated in SQL Server. and does Hosting provide provides Linked server facility?
-
Problem: I developed a website with ASP.Net and SQL Server.All data I am accessing from SQL Server. This site will hosted in public domain as internet website and it is a kind of CRM portal.My Sql server datbase has 11 tables. My company uses Oracle ERP.Now I want to update data from oracle erp to SQL Server.I have created views in Oracle as data needed in SQL Server. Means when a customer created/information updated ,it should be updated in SQL Server database. Is there any solution? I tried google but there is no suitable answers. Please reply me.
There are two posibilties Use linked server concept to link two different databse. 1. http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/[^] 2. http://www.jensbits.com/2010/11/10/create-linked-server-sql-server-2008/[^] (or) synchronize tool to sync two database at specific time(there are many tool available at affordable price).. 1. http://www.red-gate.com/products/sql-development/sql-data-compare/[^] 2. http://dbconvert.com/convert-oracle-to-mssql-sync.php[^]
-
I doubt very much that a hosting provider will allow you to configure a linked server; this needs to be done by a system administrator of the SQL Server. You should email the tech support folks at your hosting provider and ask them directly. An alternate solution would be to create a webservice on your hosted site which would process datachanges from your Oracle system. You could create a folder somwwhere on your server and write an XML file which represents the data change, then have a Windows service monitor that folder for new files and when it sees one, call the webservice to update the SQL database. It is not a real-time solution, but it would be pretty close. Good luck. :thumbsup:
-
Thanks David........ I used Linked Server,and My system administrator tell me that we are not hosting this in public domain,we host it on local IIS and we buy public IP and connect local IP to public IP. Is this possible? Is this secure?
Ah ha. I see. From my understanding if the SQL server and the Oracle Server are local, then the communication between the two should be pretty secure. I would ensure that the user accounts that you are using from your web server has the minimum privilege necessary to get the job done. You don't want to be connecting as "sa" incase your application gets hacked. During your application development, make sure you use parameterized queries to limit the exposure to SQL injection.