SQL Server - Synchronization

HI All,
  Good Morning..
  i want to implement the concept of the sql server syncronization in my Pharma Project.
for that i have gone through few articles but i dint get clear idea from where to start the process.
please can any one guide me in fulfilling my requirement.
i need syncronize multiple  databases..
Thanks in advance.



Regards
Madhu

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. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.

Replication is the process of sharing data between databases in different locations. Using replication, we can create copies of a database and share the copy with different users so that they can make changes to their local copy of the database and later synchronize the changes to the source database.

•Publisher is a server that makes the data available for subscription to other servers. In addition to that, publisher also identifies what data has changed at the subscriber during the synchronizing process. The publisher contains publication(s).
•Subscriber is a server that receives and maintains the published data. Modifications to the data at the subscriber can be propagated back to the publisher.


Microsoft SQL Server 2005 supports the following types of replication:
•Snapshot replication
•Transactional replication
•Merge replication

Steps for configuration you will find it here :
http://www.codeproject.com/Articles/28951/SQL-Server-2005-Merge-Replication-Step-by-Step-Pro

Hi madhu dont worry yaar we have an solution for synchronizing multiple databases in sqlserver.
i hope you havnt gone through the proper site.
here i am providing you a site please gothrough the below link every thing is explained very clearly about synchronization in sqlserver with multiple databases.

http://www.red-gate.com/products/sql-development/sql-comparison-sdk/learn-more/synchronizing-databases

I hope this will help you a lot.

Hi Madhu,

When we have various indipendent database for our application than generally we follow the approach of syncronization.

e.g. Company Name names in a table in a SQL Express Database on a desktop,  and a SQL Server Database in the backend. Using Sync Services for ADO.NET (if you use .net framework)developers can build capabilities into applications that can handle synchronization.

there are methods to do this.

1.)Replication methods

2.)Data Transformation Services (DTS)

3.)SQL Comparison SDK

You can follow a blog where you will get complete example of this
http://www.red-gate.com/products/sql-development/sql-comparison-sdk/learn-more/synchronizing-databases

Hope its clear now!!
Regards
D

Hi,

take a look at the http://msdn.microsoft.com/en-us/library/bb726002.aspx, formerly known as Sync Services for ADO.NET. It is an API for .NET that provides the kind of db sync capabilities which you may find helpful. From your description, the http://msdn.microsoft.com/en-us/library/bb902853.aspx seems the most applicable (peer-to-peer synchronization scenario.)

Solutuion 2
If u are not using SQL EXpress use Replication

if SQL Express use this http://www.codeproject.com/Articles/23623/Data-Synchronization-in-SQL-Express