Skip to content

Instantly share code, notes, and snippets.

@netojoa

netojoa/Initial Setup Sitecore Publishing Service.sql

Created November 7, 2018 12:01
Show Gist options
  • Save netojoa/20dc06bc3b71897aa9a968ea614b457b to your computer and use it in GitHub Desktop.
Save netojoa/20dc06bc3b71897aa9a968ea614b457b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Initial Setup Sitecore Publishing Service.sql
$sqlUser='user'
$sqlPassword = 'b'
$prefix = 'databasePrefix'
$core_connection = "Data Source=.\SQLEXPRESS;Initial Catalog=$($prefix)_Core;User ID=$($sqlUser);Password=$($sqlPassword);MultipleActiveResultSets=True;ConnectRetryCount=15;ConnectRetryInterval=1"
$master_connection = "Data Source=.\SQLEXPRESS;Initial Catalog=$($prefix)_Master;User ID=$($sqlUser);Password=$($sqlPassword);MultipleActiveResultSets=True;ConnectRetryCount=15;ConnectRetryInterval=1"
$web_connection = "Data Source=.\SQLEXPRESS;Initial Catalog=$($prefix)_Web;User ID=$($sqlUser);Password=$($sqlPassword);MultipleActiveResultSets=True;ConnectRetryCount=15;ConnectRetryInterval=1"
.\Sitecore.Framework.Publishing.Host configuration setconnectionstring core $core_connection
.\Sitecore.Framework.Publishing.Host configuration setconnectionstring master $master_connection
.\Sitecore.Framework.Publishing.Host configuration setconnectionstring web $web_connection
.\Sitecore.Framework.Publishing.Host schema upgrade --force
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment