Advertisement

03.31.2008 at 05:38AM PDT, ID: 23282211
[x]
Attachment Details

Synchronisation of two tables between 2 SQL-Server instances

Asked by nikkiso in MS SQL Server, MS SQL DTS, SQL Server 2005

Tags: , ,

Hello all,

following scenario:

I have one SQL Server 2005 Standard and probably either one SQL Server 2000 or another SQL Server 2005 instance running.

On both server instances will be a database with a certain table, i need to sync at frequent intervals.
This table is very straight forward, so at the moment i do not have informations about existing triggers, sp's or so on.

In both tables we have to insert and update rows that must be availabe shortafter in each table.

What is the most suitable way to synchronize theese tables???

Thanks for reply!!!

JanStart Free Trial
 
Keywords: Synchronisation of two tables betwee…
Title
1 GAL synchronization
2 MySQL synchronization
3 sql server mobile synchronization acro…
4 Outlook 2003 Synchronization
5 Backup/Sync Software
6 Database sync W2K3 --> W2K
 
Loading Advertisement...
 
[+][-]03.31.2008 at 05:42AM PDT, ID: 21244807

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, MS SQL DTS, SQL Server 2005
Tags: Microsoft, SQL Server, 2000, 2005
Sign Up Now!
Solution Provided By: chapmandew
Participating Experts: 3
Solution Grade: A
 
 
[+][-]03.31.2008 at 06:05AM PDT, ID: 21244932

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.31.2008 at 06:08AM PDT, ID: 21244950

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.31.2008 at 08:27PM PDT, ID: 21251026

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.31.2008 at 08:29PM PDT, ID: 21251037

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.01.2008 at 12:46AM PDT, ID: 21251976

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.01.2008 at 05:26AM PDT, ID: 21253180

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628