Click here to Skip to main content
11,581,130 members (64,434 online)
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 7-Feb-13 23:07pm
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 OriginalGriff 210
1 Frankie-C 195
2 Sergey Alexandrovich Kryukov 85
3 F-ES Sitecore 80
4 Andy Lanng 75
0 OriginalGriff 1,108
1 Sergey Alexandrovich Kryukov 785
2 Abhinav S 622
3 F-ES Sitecore 500
4 Suvendu Shekhar Giri 433


Advertise | Privacy | Mobile
Web04 | 2.8.150603.1 | Last Updated 8 Feb 2013
Copyright © CodeProject, 1999-2015
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