How to connect two different servers simultaneously ?

Question

0.00/5 (No votes)

See more:

Hi,

I want to use two different servers which are connected in a same network in my windows C# application like Inserting,deleting same data into the two servers simultaneously.

For Example, We have two servers server A and Server B
i want to insert same data in both server A and server B.

server A and server B have same database.

Can any know about this concept ?

Thanks

Posted 22-Oct-13 18:23pm

Mr. Avskmk

Add a Solution

Comments

Madhu Nair 23-Oct-13 0:24am

Why don't you use two different connection string in your app.config file?

Mr. Avskmk 23-Oct-13 0:28am

If we use two different connections, that many times we need to do insert action..
If we need to insert multiple record around 500 then it will take time...

Thanks7872 23-Oct-13 0:41am

Mr. Avskmk wrote:
many times we need to do insert action

If you want to insert data then you have to. What is wrong with that? Nothing works AUTOMATICALLY.

Sergey Alexandrovich Kryukov 23-Oct-13 0:31am

First of all, why? And why it can be a problem?
—SA

Herman<T>.Instance 23-Oct-13 7:33am

why you do not setup a replication between the servers ?

3 solutions

Solution 1

you can declare 2 connectionstrings and use the same sql query to perform the operation(ecexute same query twice using different connectionstring)

Posted 22-Oct-13 18:27pm

Member 8622273

Solution 2

I'd use two connections; I do so all day long.

Or you could use a trigger... but I don't recommend it.

Posted 22-Oct-13 18:34pm

PIEBALDconsult

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)

Mubin M. Shaikh · Accepted Answer · 2013-10-23T00:37:00

Hi,

First of all you need to decide within how much time gap you want to update data, as per that you can create ssis ETL package which will run on that time interval and update your data on machine2.

You can also go for Replication option.

There are many ways we can choose as per the requirement.

let me know if you need any further assistance.

Regards,
Mubin