Database Synchronization Logic

Question

2.00/5 (1 vote)

See more:

I want to make / Use existing Framework which is used to sync Application database having Large amount of data. Database in each application is sql server.
Can you suggest me what shall be my approach?

For example I have 4 different applications having sql server database(All large data). Ultimate thing I have to do is to provide MDM , A synchronized master database.
So, Is that any tool or Framework which can help me to make a common database which will sych data of particular entity and attributes on Insert, update, delete operations.

Posted 3-Oct-15 0:04am

Member 12003400

Updated 3-Oct-15 1:07am

v2

Add a Solution

Comments

José Amílcar Casimiro 3-Oct-15 6:15am

Your question is not clear. What do you want to do?

2 solutions

Add a Solution

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)

OriginalGriff · Answer 1 · 2015-10-03T00:29:00

Solution 1

When you get a "big subject" query like this, the first thing to do is to start by looking at Google: "database synchronization"[^] and trying to work out if you can either find a solution there, or at least eliminate some options to make the question smaller and "more answerable". Have a look at some of the links, and see what fits your circumstances - there are so many options that could be what you are trying to achieve that anything we suggest at this stage is almost certainly wrong! :laugh:

Posted 3-Oct-15 0:29am

OriginalGriff

Comments

Member 12003400 3-Oct-15 6:48am

Well I already did googling . The only motto pf asking this question is it would reduce my time, research if anyone has done something similar like this before.

OriginalGriff 3-Oct-15 6:52am

The trouble is that we know nothing about what you are trying to achieve other than exactly what you have told us - which is really nothing at all!

So all you would be doing is "saving you time" by loading it onto us and spending even more time trying to work out if what we might suggest fits your circumstances!

Try cutting down the options first to make our answers more relevant.

Member 12003400 3-Oct-15 7:08am

I hope this sounds more helpful than before

Maciej Los · Answer 2 · 2015-10-03T11:27:00

Solution 2

If you want to get few instructions how to provide MDM, please, take a look here:
The What, Why, and How of Master Data Management[^]
Master Data Management (MDM) Hub Architecture[^]

Posted 3-Oct-15 11:27am

Maciej Los