MartinMiles

# Usage:
# .\ConvertTo-PublishingModuleWdp.ps1 -SitecoreAzureToolkitRoot "C:\Sitecore\SAT" -Path "C:\Sitecore Publishing Module 3.1.4 rev. 200110.zip" -Destination "C:\output"

[CmdletBinding()]
Param(
    [Parameter(Mandatory=$true)]
    [ValidateScript({ Test-Path $_ -PathType Container -IsValid })]
    [string]$SitecoreAzureToolkitRoot,

    [Parameter(Mandatory = $true)]

MartinMiles

# Usage for this scrtip:
# .\ConvertTo-PublishingServiceWdp.ps1 -Path "C:\Sitecore Publishing Service  3.1.1 rev. 180807-x64.zip" -Destination "C:\output"

[CmdletBinding()]
Param(
    [Parameter(Mandatory = $true)]
    [ValidateScript({ (Test-Path $_ -PathType Leaf) -and ($_ -match '\.zip$') })]
    [string]$Path,

    [Parameter(Mandatory=$true)]

MartinMiles

gci -r -include "*.yml","*.xml" | foreach-object { $a = $_.fullname; ( get-content $a -Encoding UTF8) | foreach-object { $_ -replace "FROM VALUE","TO VALUE" } | set-content $a -Encoding UTF8}

MartinMiles

-- you should have you DB up& running (for example, after restoring)
-- then you need to detach the database and delete that huge .LDF file
-- it will get re-created upon re-attaching by using the below command

CREATE DATABASE databasename
ON (FILENAME= 'c:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\databasename_web.mdf')
FOR ATTACH_REBUILD_LOG
GO

MartinMiles

Set-ExecutionPolicy RemoteSigned
Import-Module -Name SPE
 
$session = New-ScriptSession -Username admin -Password b -ConnectionUri https://platform
 
Invoke-RemoteScript -ScriptBlock {
    Get-Item -Path "master:\content\Home"
} -Session $session

MartinMiles

Invoke-Sqlcmd -ServerInstance "(local)" -Query "`
            DECLARE @dbnames NVARCHAR(MAX) SET @dbnames = ''`
            DECLARE @alter NVARCHAR(MAX) SET @alter = ''`
            DECLARE @statement NVARCHAR(MAX) SET @statement = ''`
			`
            SELECT @dbnames = @dbnames + ',[' + name + ']' FROM sys.databases WHERE NAME LIKE 'Platform_%'`
            SELECT @alter = @alter + 'ALTER DATABASE [' + name + '] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;'  FROM sys.databases WHERE NAME LIKE 'Platform_%'`
            IF LEN(@dbnames) > 0`
            BEGIN`
                   EXEC sp_executesql @alter`

MartinMiles

<?xml version="1.0" encoding="utf-8"?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:role="http://www.sitecore.net/xmlconfig/role/" xmlns:search="http://www.sitecore.net/xmlconfig/search/">
  <sitecore role:require="Standalone or ContentDelivery or ContentManagement" search:require="solr">
    <contentSearch>
      <configuration type="Sitecore.ContentSearch.ContentSearchConfiguration, Sitecore.ContentSearch">
        <indexes hint="list:AddIndex">
          <index id="sitecore_preview_index" type="Sitecore.ContentSearch.SolrProvider.SolrSearchIndex, Sitecore.ContentSearch.SolrProvider">
            <param desc="name">$(id)</param>
            <param desc="core">DigitalEcosystem_preview_index</param>
            <param desc="propertyStore" ref="contentSearch/indexConfigurations/databasePropertyStore" param1="$(id)" />

MartinMiles

<?xml version="1.0" encoding="utf-8" ?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/">

  <!--
  
  This configuration adds "preview" publishing target as a copy of production-like "web" database for Sitecore 9.3
  Please refer to a full guide video for the usage instructions: https://youtu.be/...

  WARNING!
  This configuration is done for demo purposes only, do not use it as is.

MartinMiles

user_pref("browser.bookmarks.showMobileBookmarks", true);
user_pref("browser.ctrlTab.previews", true);
user_pref("browser.download.autohideButton", false);
user_pref("browser.download.panel.shown", true);
user_pref("browser.library.activity-stream.enabled", false);
user_pref("browser.newtabpage.activity-stream.feeds.places", true);
user_pref("browser.newtabpage.activity-stream.feeds.section.highlights", false);
user_pref("browser.newtabpage.activity-stream.feeds.telemetry", false);
user_pref("browser.newtabpage.activity-stream.filterAdult", false);
user_pref("browser.newtabpage.activity-stream.prerender", false);

MartinMiles

$SitecoreModuleName = 'SitecoreInstallFramework'
$SitecoreRepositoryUrl = 'https://sitecore.myget.org/F/sc-powershell/api/v2'
$SitecoreRepositoryName = 'SCGallery'

# Install NuGet package repository
Install-PackageProvider "NuGet" -MinimumVersion 2.8 -Force | Out-Null

# Install Sitecore's powershell gallery
$SCGallery = Get-PSRepository $SitecoreRepositoryName -ErrorAction SilentlyContinue
If ($null -eq $SCGallery) {