Hello and welcome everybody to our TNWiki Article Spotlight on Tuesday.
Replication is one of the most helpful techniques when working with databases in production. One specific kind of replication is called transactional replication. Transactional replication enables administrators to synchronize committed commits/transactions to one or multiple target databases. SQL Azure Database: Understanding Transactional Replication Step by Step, created by Bhushan Gawale, shows how to use transactional replication with a SQL Azure Database. He starts with the theoretical basics of transactional replication and then starts a bigger demonstration. The demonstration starts with the creation of a SQL Azure Database, how to configure it and how to setup SQL Server Database Publication. At the end he shows how to create a subscription and how to validate the setup.
If you have the need to move your databases or synchronize your production database to a backup server, transactional replication is one technique you can use to achieve this goal.