Skip to content

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

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

31 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

My basic replication presentation (Google slide)

link to the presentation

Requirement

At least SQL Server Developer edition 2014 Now, Microsoft SQL Server Developer is free now, you can down load from

For 2014: https://my.visualstudio.com/Downloads?q=SQL%20Server%202014%20Developer

For 2016: https://my.visualstudio.com/Downloads?q=SQL%20Server%202016%20Developer

If you have installed SQL computer, you can check with the following query.

SELECT @@VERSION AS SqlServerVersion

You need three SQL server instances for:

  • Publisher
  • Subscriber
  • Distributor

To setup replication with create a new database

  • Launch a new PowerShell terminal
  • CD to the root of the project
  • Open Install-Replication.ps1 and change all variables to match your need.
  • Run the Install-Replication.ps1 script
. \Install-Replication.ps1
  • After setup is successfully, you will have a new database with replication setup

To remove replication

  • Run the Install-Replication.ps1 script

Testing a replication

  • Run New-ToDoItem.ps1

About

example scripts to create SQL Server replication

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages

  • TSQL 53.4%
  • PowerShell 45.0%
  • Other 1.6%