Basic replication presentation (Google slide)

link to the presentation

To use this example

Launch a new PowerShell terminal.
Start SQL Server docker containers.
CD to docker folder.
Create a new file 'sa_password.secret' and put a strong sa's password to this file. Please make sure that you use LF line feed.

Optionally, you may need to run the following commands if files get converted to CRLF

$path = ".\sa_password.secret"; (Get-Content $path -Raw).Replace("rn", "`n") | Set-Content $Path -NoNewline -Force
$path = ".\entrypoint.sh"; (Get-Content $path -Raw).Replace("rn", "`n") | Set-Content $Path -NoNewline -Force

Run a docker-compose command with a following command.

    docker-compose up

Alternatively, if you want to force build an image, use

    docker-compose up --build

Wait for a while and you will have publisher, distributor and subscriber instances.
You can connect to each SQL Server instance with this information .
publisher: localhost, 2000
distributor: localhost, 2001
subscriber: localhost, 2002

Create a new database and setup replication

Launch a new PowerShell terminal.
CD to the root of the project.
Execute the following commmand to setup replication.

    .\Install-Replication.ps1

After setup successfully, you will have a new database with replication.

Testing a replication

Run New-DatabaseRecord.ps1. It will excute stored proc to insert a new record to publisher and then select records from subscription database.

    .\New-DatabaseRecord.ps1

Troubleshooting

Your SQL Sever is very slow or cannot create all instances

For multiple containers, you may need to add ram to 6 GB because each SQL Server instance can consume up to 2 GB.

codesanook/codesanook-sql-server-replication-setup-script

ErrorLooks like something went wrong!

About

Topics

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Languages

Error
Looks like something went wrong!

Packages