?
Solved

SQL Server 2005 - Syncronising Tables

Posted on 2009-12-18
1
Medium Priority
?
206 Views
Last Modified: 2012-05-08
Hi,

I have two machines running SQL server 2005. One (lets call this machine A) has many databases and contains data which is requied by the other machine (machine B). On a nightly basis i want to update a table in a database stored on machine B. The table will be updated from 2 different tables (in different tables) from machine A. The two tables in A also contain different fields from one another....some of these fields also need to be sync'd with the table on machine B (these are nullable fields....so when getting synd with a table not containing these fields then it would have a null).

What is the best way to get this synconisation to work?

Thanks
0
Comment
Question by:fred2k3
1 Comment
 
LVL 8

Accepted Solution

by:
MOA81 earned 2000 total points
ID: 26084116
Dear fred2k3,

the best to do is through replication

Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.

http://www.sql-server-performance.com/articles/dba/sql_server_2005_replication_gui_p1.aspx
http://www.exforsys.com/tutorials/sql-server-2005/sql-server-configuring-replication.html
http://www.informit.com/articles/article.aspx?p=599700

The below link are tutorial which will guide you on bases on how to do this
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question