Skip to content

Latest commit

 

History

History
 
 

replication

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 

README.md

SQL Server Replication with Containers

This demo uses docker-compose to start two SQL Server containers; one that acts as the publisher and distributor, and the other as the subscriber in a push snapshot configuration.

How to Use

  1. Run the following command in this directory:
docker-compose up

note: this will take approx. 2 min.

In your terminal, you should see something like this

db1    | Job 'DB1-Sales-SnapshotRepl-1' started successfully.
db1    | Creating Snapshot...
db1    | Job 'db1-Sales-SnapshotRepl-DB2-1' started successfully.
  1. Connect to the subscriber listening on localhost,2600 and see that the Sales Database has a Customer table with data in it. note: credentials are listed in the docker-compose.yml

  2. when you are done, clean up by running the following command

docker-compose down

How it Works

  1. Both SQL Server containers start with the environment variables specified in the docker-compose file. In this example, db1 is the publisher/distributor and db2 is the subscriber.
  2. db1/db-init.sh and db2/db-init.sh waits for SQL Server to start up and run the db-init.sql scripts
  3. db1/db-init.sql creates a Sales Database with Customer table and sample data, and proceeds by setting up snapshot replication.
  4. db2/db-init.sql creates a Sales Database.
  5. db1 starts replication jobs to push the snapshot to db2