954,593 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

How to synchronized the tables from sql server 2000 to sql server 2005 ?

HI,
Am having a table named "test" in the server A -> running Sql Server 2000.

synchronized in server B (Insert,update and delete in the server A)


Am having the same table named "test" in the server B -> running Sql Server 2005.


I don't know, how to carry out this process. Please help me out. Please anyone give me a step by step guide to carry out this task. Great help...

jacksantho
Junior Poster
164 posts since Feb 2011
Reputation Points: 7
Solved Threads: 0
 

This is not a subject for the faint of heart, and it's not something you can just "cookbook" on a forum web site.

There are several different methods. You can use Replication (the "Publish/Subscribe" model), you can use linked servers, you can do log-shipping, you can use changed-data-capture with periodic updates (with DTS or SSIS depending on where you want it to run). Depending on how fancy you want to get and how much you want to spend, there's always mirroring and clustering.

If you are new to the subject area, you should probably read the manual's "Replication" section to see if that fits your need. It's the simplest to implement, has the fewest security headaches and isn't particularly a resource hog.

Good luck!

BitBlt
Master Poster
711 posts since Feb 2011
Reputation Points: 367
Solved Threads: 109
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You