Database Synchronization of Remote Databases

Question

0.00/5 (No votes)

See more:

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

kunal jangade

Add a Solution

Comments

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 ?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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