Hi,
I have two different projects. But now I want to provide the communication between the projects. Their main tables has 3 same fields. I want to read first project's main table and write another project's main table. How can I do that fast? Because first project's data is grown very fast(e.g 100 datas in a second). What is the best way?
Loading
Mahesh ChandPosted Dec 1, 2009, 11:14 AM
If you want to share data from two databases in two different applications. There are several ways to do it.
1. You can have two database connections opened direct with two databases
2. You can have two Web Services exposing data from these two databases and let applications consume these Web services.
3. Data between application to application can be shared using .NET Reporting or DCOM
GurkanPosted Dec 3, 2009, 3:17 AM
Piotr JustynaPosted Dec 1, 2009, 9:33 AM
Is there a possibility in your case to write a windows service on your database server which will synchronize both databases?
GurkanPosted Dec 1, 2009, 9:13 AM
But they are two different projects and two different databases. My first solution is to use Web Handler. But First project's datas have to be automatically written to another's database. Automatically operation, not manual. So it is useless.
So, how can I apply your solution? I can't find the way to provide the communication of these distinct projects.
Piotr JustynaPosted Dec 1, 2009, 8:45 AM
Just bind the second table to first table's datasource and refresh it with desired time interval.
If you like my answer please mark it as helpful.
Cheers!