locked
sync services for ado question RRS feed

  • Question

  • Hello, I have a question about using sync services for ado.net. I have 2 databases, both in SQL Server 2005. Both are separate commercial databases. The are different schema's but have many similarities. What I am trying to do is allow users to insert, update information in database A and then push applicable changes or new records to database B.

    I am coding this with ado.net now and massaging the data to move it from A >> B as needed. I this possible with sync services, and would this provide a better framework for building this out?

    Thanks

    Ryan
    Sunday, December 14, 2008 4:33 PM

Answers

  • You should definitely take a look at the features of Sync Service for Ado.Net. Its functionalities cover the scenario you want to implement and will make it very convenient. I believe the shipped version has SQL CE 3.5 client provider ready for use, but for other Sql server types as client, you will need to do some extra work yourself.

    Sunday, December 28, 2008 2:57 AM
    Answerer