Transactional Replication : How to configuration in SQL Server 2008

In this Video Tutorial you will learn:-

How to configure SQL Server 2008 Database Transactional Replication.
What network protocol you should enable.
How to open ports on the windows firewall for SQL Server communication on the network.

SQL Server Ports to be open for Replication: 1433, 137.

Transactional replication mainly used in scenarios that require server to server high throughput, which includes: scalability and availability; data warehousing and reporting; integrating data from multiple sites; integrating heterogeneous data; and offloading batch processing.

Download Deme-Replication database backup:

Also See:-
How to Automate SQL Server express backups on Windows Server 2012

Planning and Architecture (Replication)

[andresjesusrodriguez]

We were using JMS to simulate replication...Thanks a lot!!!! great salute from Argentina

[clapton]

Awesome video. When you said 'secret password I'm not going to tell you' for the 3rd time I couldn't stop laughing.

[samsclips]

Thanks Sachine. You did a wonderful job.

[RahdixCloudNine]

Thank's for Your video Samy..I will try it on my development machine and I will not post the result here..that will be very secret I'm not going to tell You. :)

[fatimahussain]

Thanks, this is very informative video and I will try on my development server. Result will be really secret and I am not going to tell you (enjoy a lot this statement ) hahaha

[benarjigopaluni]

Good presentation and explanation Sachin. Thank you

[gohostingdemo]

Thank you very much this video is very helpful !!!

[anonymoustruth]

very good video... i also find it amusing when you say "password is very secrete and im not going to tell you..."

[deepikajoshi]

Need one help... Is there any way to pause replication and i can refresh subscriber full database and then resume replication

[preranabohara]

HI Sachin, I am unable to find  SQLServerAgent in groups, to add for access in repldata folder. I am not sure what can be the reason whereas my sqlagent is in automatic running mode.

[kgaugelosithole]

Great video, I'd like to ask is it possible to replicate a on-site server to an AWS server

[gnkurup]

Its an awesome video. Sachin thank you very much.

[maimunsupplies]

Hi Sachin  I have 2 PC running windows 7 and have installed SQL SErver 2008R2 for the instances. I recently installed sql server 2014 with ssms. I need to replicate the database on one pc as publisher to another database on the second PC. I just want to push the data for now. In my ssms after I connect to the database the replication rightclick does not give me option to configure distribution. I just have replication monitor and option of Local Subscriptions. Why is this? Please advise

[sivan]

how to use, add sql subscriber using tcpip with port

[maabs]

Hi Sachin, can you please provide the video like how to configure transactional replication with updatable subscribers on different domain sql servers. PLz

[mohamedrafi]

Good explanation friend. Keep going and good work

[vijaydr]

Nice video sachin... It really helped a lot.. Detailed Step by step Guide for configuration..!!! POst videos on Database Mirroring and Cluster failover too...

[nathltd]

Wow! Awesome tutorial on replication. Sachin I want to ask if a record is inserted, updated or deleted on SERVER-3 will it replicate on SERVER-1? Thanks.

[UmerAzeem]

Replicatin over the internet is possible ? without VPN/FTP.
COuld you please guide me how to configure that., .,
i have two Servers..one in US (Directly on public ip ) and second in KSA (behind NAT device)...i want to enable replicate from KSA to USA Server without VPN\FTP...plz guide me how to do

[freeanto]

nice, funny... but a little bit complicated