How Do I - Setup Transactional Replication

Transactional replication is a feature of SQL Server that replicates committed changes to the publisher database to one or more subscriber databases. Transactional replication is useful when you need data that is up to date in different locations. In this video Scott Golightly shows how to set up transactional replication. First the publisher is configured, then the distributor, next publications with articles are created, and finally a subscriber is created. The video shows making changes to the publisher database and having those changes appear at the subscriber.

Presented by Scott Golightly.

[manikantanvsr]

How do we get this adevneture workspace

[HowerS]

Just wanted to say thanks.  Made setting this up for the first time a breeze.

[fth]

Thanks, very useful tutorial.

Could you configure the replication publisher to publish all databases on the server ?
i.e. if a new database is created could this auto publish and replicate to the subscriber ?

Or does a new Replication Job need to be setup ?

Thanks

[S]

You would have to configure the new replication just as from this clip. Microsoft SQL Server does not provide automatic replication.

[ponytripstudios]

Thanks for posting this. The MS website wouldn't let me watch this <_<.