Replication Setup:

 

I saw too many questions on forum asking step by step process of configuring replication I have these links in my favorites so though consolidating it.

For Sql Server 2000:

Snapshot Replication setup:

By Alexander Chigrik 

http://www.databasejournal.com/features/mssql/article.php/1458491/Setting-Up-Snapshot-Replication-A-Step-by-step-Guide.htm

Transaction Replication setup:

This is by Alexander Chigrik at database journal you can also find the same at mssqlcity.com

http://www.databasejournal.com/features/mssql/article.php/1438201/Setting-Up-Transactional-Replication-A-Step-by-step-Guide.htm

Merge Replication setup:

This is also by Alexander Chigrik 

http://www.databasejournal.com/features/mssql/article.php/1438231/Setting-Up-Merge-Replication-A-Step-by-step-Guide.htm

Another for merge replication by D J Nagendra

http://www.codeproject.com/KB/database/MergeReplication.aspx

and more information about replication and step by step by Mahesh Kodli

http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000-Part-2/

For Sql Server 2005:

Transaction Replication setup:

I always refer this great link by longrujun

http://blog.csdn.net/longrujun/archive/2006/06/09/783357.aspx

Merge replication setup:

here is link by Ahmad Eid Salim 

http://www.codeproject.com/KB/database/sql2005-replication.aspx

Finally To Implement Bidirectional Transactional Replication:

http://support.microsoft.com/kb/820675

(added 11242009)

Peer to Peer Transactional replication script:

http://www.dberrorcode.com/sql-server-2005-peer-to-peer-transactional-replication-setup/

(add12022009)just read a great blog by Gurwinderjit Singh

Step by Step Procedure to Implement SQL Server Transactional Replication with Oracle as Publisher

http://blogs.msdn.com/sqlserverfaq/archive/2008/10/16/step-by-step-procedure-to-implement-sql-server-transactional-replication-with-oracle-as-publisher.aspx

Thanks you very much to all the bloggers to share this valuable information with us.

I will try to keep this up to date. Appreciate more links if you have any.

Thanx.

Vinay

twitter @thakurvinay

Advertisements
This entry was posted in Replication and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s