Connect a Web Site Database using Dot NET.

Question

I have one ERP, which uses on Database (SQL Server 2005), and one Web Site that uses another Database (MySQL). In both Databases I have the same data duplicated. When I update one data in ERP Database, I want to update automatically the Database of the Web Site.

I think the better way to do this is to create one connection from the ERP (using Dot NET language) to the Web Site Database. How can I do this connection? After the connection done, can I use SQL queries in order to update the Web Site Database?

Thank you very much!

Answer 1

Hi,
What I understand you should do in between databases.

Options!

1, Put triger on Table  and when ever change occurs in one database, do change or update on other database.

2, I not much familiar but use SSIS between two database to make data consistent.

---

EME