what is the best way for synchronize data?

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

Now I face problem with synchronize data.I write C# with Sql server and I am finding the best way for synchronize data with many branch to HQ.could anyone tell me the best way for solve this problem? I am really dizzy...

waiting to hear from your help...

thank in advanced.

Posted 8-Feb-15 17:30pm

kornkimhour

Updated 8-Feb-15 17:31pm

v2

Add a Solution

Comments

PIEBALDconsult 8-Feb-15 23:32pm

Replication? Log Shipping?

kornkimhour 9-Feb-15 2:29am

after my branches sale data.the data will automatic send to HQ.if the connection lost,the data will keep in local and it will resend to HQ when it has connection.so do you have an idea about that?

[no name] 8-Feb-15 23:45pm

Can you please explain what kiind of issue you are facing here? For synchronizing the data means what kind of data you are talking about here? Is it same as I am having a table of data in a database and I want to synchronize the table of data from the production environment in a particular interval of time such as once in a week or month?

kornkimhour 9-Feb-15 2:28am

after my branches sale data.the data will automatic send to HQ.if the connection lost,the data will keep in local and it will resend to HQ when it has connection.so do you have an idea about that?

[no name] 9-Feb-15 6:03am

I don't know how you are keeping your data here. I can suggest a way for doing this. Lets assume your data is in XML format. If you are keeping your data in a file for each branch then you can generate one file for each branch. Keep them in a folder and then schedule a console programe in the windows task scheduler which will execute in a particular interval of time and if it finds a file (from any branch) then it will process thedata with the connection and after successfully transfering the data it will delete the file. In this way you can achieve the solution. If there is no connection it will try for a particular instance. you can mention the number of instances that can try for in the task scheduler itself.

Sinisa Hajnal 9-Feb-15 2:12am

Or each of the branches has its copy of the data and you have to keep it in sync with HQ? If so, why? Is it impossible to have them all connection to HQ database?

kornkimhour 9-Feb-15 2:28am

after my branches sale data.the data will automatic send to HQ.if the connection lost,the data will keep in local and it will resend to HQ when it has connection.so do you have an idea about that?

Sinisa Hajnal 9-Feb-15 3:45am

Yes, I did similar things on a system that has unstable networks due to storms (ships traveling to the islands) - you have to have a poll (timer) on branch side that will occasionaly when the network is available send the data.

I did it like this: try to send the data to HQ immediately...if you get confirmation, mark the data as sent and write into local DB. If you get an exception, write into local DB, leave the data unconfirmed (will be sent next time when the network is available)

When the network is down, show button "establish connection and upload" for manual trigger (which will of course fail if the network is unavailable) - it serves only as a visual remainder that network is down and saves couple of minutes if people don't want to wait for timer to trigger the sync.

kornkimhour 9-Feb-15 4:19am

thank for your idea.It can be solve this problem.I used to think about timer but before I use the timer, I want to research and find the best way for sync data.when I research at google, SSIS is the best way for sync data but I don't know how it work,how it is good and how it is work when connection lost.I really dizzy about that but thank you anyway.if you have more idea, I hope you can tell me detail.

Sinisa Hajnal 9-Feb-15 5:01am

SSIS is true server replication. It is difficult to setup, but once you have it it will work and not depend on your programming skill. I've seen it used, but I choose programming way as I'm more comfortable with it and I have more control over it.

kornkimhour 9-Feb-15 5:12am

that a great idea.I've seen it too and it is really hard to learn.how about Microsoft synchronize Framework.have you ever had an experience about that? please share if you have an idea.

thank you for your best idea.

Sinisa Hajnal 9-Feb-15 5:14am

No, I didn't have an opportunity - after I finished the above mentioned product, I've changed jobs so...opportunity lost :)

kornkimhour 9-Feb-15 5:22am

never mind.I'm really thank that you try your best for help me.I will try to search more about Microsoft synchronize Framework.I will use timer if I can not find other best way. have a nice day :D

Mohammad Reza Valadkhani 9-Feb-15 3:34am

please provide more explanation, you just copy and paste same sentence to the all others comments!

kornkimhour 9-Feb-15 3:57am

EX: I have 5 branches so I want to create central sale report that why I need to sync all branches sale data to one server.

The way I worry is that the connection lost so do you have an idea about that?
if you are not sure. you can ask me more detail.

Thank you for command.....

Mohammad Reza Valadkhani 9-Feb-15 4:35am

i recommend you use WCF duplex form, so when ever you have connection send data to your server, and when you don't have store it in local DB, as the other said, i`ve used WCF for 5000 branch in my project also i could see which branch is online or offline in central monitoring by my service. also as the other said use flag for sent data to determine which one is sent, and send time within your data to find exact time on your record.

kornkimhour 9-Feb-15 5:05am

I don't want to check my connection lost or not.the thing that I want to do is that:technique for send data from client to server.EX: timer or..

but thank anyway.if you have more idea,I am really happy to get your idea.

Mohammad Reza Valadkhani 9-Feb-15 5:08am

so try WCF

kornkimhour 9-Feb-15 5:28am

why we use WCF for sync data? WCF: we use when different platform or b2b so it suitable or not to use it for sync data?

Mohammad Reza Valadkhani 9-Feb-15 5:35am

yeah but we could implement sync functionality into it
We Have Sync Framework here it could help you

https://jtabadero.wordpress.com/2010/03/08/sync-framework-wcf-based-synchronization-for-offline-scenario-%E2%80%93-using-custom-dataset-serialization/

kornkimhour 9-Feb-15 5:37am

thank i will check it

Herman<T>.Instance 10-Feb-15 3:35am

Always On Avail Groups -> https://technet.microsoft.com/en-us/library/ff877884.aspx

kornkimhour 10-Feb-15 22:04pm

thank you.I think it is good after i read it but I need to learn it for detail :)

Herman<T>.Instance 11-Feb-15 5:08am

Busy on learning that too now. Bought a sql server 2014 developer edition at the M$ Store. Gonna test the feature in the comming weeks.

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)