Replciation Sql Server 2005...Please Help

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

I need to replicate data from 2 database into a single database

Scenario

We have developed an application for Transport Company. They have two location in two town.

We have a databases at each of locations.

We need to transfer data at regular intervals from these individual databases into our main database at a centralized place .

What would be the best solution for the above scenario

--
Thanks
Anoop Nair

Life is a challenge, and I’m staying in the game to win.

Posted 3-Dec-10 21:20pm

nairanoopp

Add a Solution

Comments

sandipapatel 4-Dec-10 3:56am

I was facing same problem in restoring older database to current one.
I was using queries for selecting all data from same named table from both database and then comparing them and updating current db accordingly if new values are available or values are changed for rows.

New Approach:
You can map your database schema (all tables and fields) to an XML file.
Then go -----------
foreach node in xmlnodeofthexmlfile
getdata and compare for both db's same named tables.

It will be very easy. Try out this 1 as 1 organization is using this approach as I heard from my friend who's working in it. You won't need modification in this module ever even if u change the database schema. U need to simply update the XML file only.

fjdiewornncalwe 6-Dec-10 9:42am

A good suggestion in a disconnected environment. Just as a question because you haven't put this information in your question... Are the two satellite servers and the main server connected via internet in any way or can be? If you are fortunate enough to have that you could investigate Replication as a potential solution as well.

1 solution

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)

nairanoopp · Answer 1 · 2010-12-06T03:52:00

Solution 1

Yes they are connected via internet

We are also trying for replication in Sql Server 2005.

But we need to get data from 2 different Db's into a single DB

This is causing us a problem due to indentity column and primary ley columns

Posted 6-Dec-10 3:52am

nairanoopp