Click here to Skip to main content
Rate this: bad
good
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 8-Feb-13 0:07am
Comments
Bala Selvanayagam at 8-Feb-13 5:22am
   
you could try replication ?
kunal jangade at 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 at 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 at 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 at 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 at 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 at 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
0 Sergey Alexandrovich Kryukov 575
1 Kornfeld Eliyahu Peter 409
2 Maciej Los 369
3 DamithSL 196
4 OriginalGriff 188
0 OriginalGriff 6,353
1 DamithSL 4,854
2 Maciej Los 4,476
3 Kornfeld Eliyahu Peter 4,058
4 Sergey Alexandrovich Kryukov 3,917


Advertise | Privacy | Mobile
Web03 | 2.8.141220.1 | Last Updated 8 Feb 2013
Copyright © CodeProject, 1999-2014
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