Click here to Skip to main content
13,045,920 members (47,686 online)
Rate this:
Please Sign up or sign in to vote.
The issue is I have my database at my machine, the application is developed and given to the users. The user uses the application daily updating, inserting and deleting data, what I want is that I get all the data in my database, the users are located at remote place. As the size of database will keep on increasing everyday i cannot restore my database everyday. So if it is possible to have arrangements such that I get only the new data other then that i got a day before. Can any one give me ideas to implement this thing?
Thanks in advance.
Posted 7-Feb-13 23:07pm
Bala Selvanayagam 8-Feb-13 5:22am
you could try replication ?
kunal jangade 8-Feb-13 5:33am
We have 3 types of replication, which one would fit the best for this? Is it also possible with Microsoft sync Framework?
Bala Selvanayagam 8-Feb-13 7:11am
It depends on many factors like the database ( hope its SQL server) version, band width you have between your server and remote database, your exact requirement, your expertism and etc
kunal jangade 9-Feb-13 3:44am
I am using SQL server as database, i don't know exactly the bandwidth term but it nearly 200 miles. my exact requirement is i want data if possible in real time or else on a routine basis e.g. once in a day. Do you have any idea regarding this?
CHill60 8-Feb-13 9:49am
Like I said the last time ... Transactional Replication and Sync is probably the best solution for you in this case
kunal jangade 9-Feb-13 3:46am
ok let me try it out if it works with transactional replication. writing Sync you mean Microsoft Sync framework?
Bala Selvanayagam 9-Feb-13 13:10pm
I read your other post, you may fall into legal issues if you do this without the knowledge of the user - data protection act ?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 8 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100