SQLServerJobRunner/deploy-master.cmd at main · SQLauto/SQLServerJobRunner · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
@echo off

set SQLPACKAGE_ROOT=%~dp0.sqlpackage\
set PATH=%SQLPACKAGE_ROOT%;%PATH%
set TARGET_SERVER=localhost
set DATABASE_NAME=master
set SOURCE_FILE=.\src\MasterDB.Build\bin\Release\netstandard2.0\MasterDB.dacpac

if not exist "%SQLPACKAGE_ROOT%\sqlpackage.exe" (
    call restore.cmd
)

echo Target server^: %TARGET_SERVER%
echo Target database^: %DATABASE_NAME%

sqlpackage.exe ^
/Action:Publish ^
/SourceFile:%SOURCE_FILE% ^
/DeployScriptPath:%DATABASE_NAME%.deployscript.sql ^
/DeployReportPath:%DATABASE_NAME%.deployreport.xml ^
/OverwriteFiles:True ^
/TargetServerName:%TARGET_SERVER% ^
/TargetDatabaseName:%DATABASE_NAME% ^
/TargetEncryptConnection:True ^
/TargetTrustServerCertificate:True ^
/p:IgnoreWhitespace=True ^
/p:IgnoreSemicolonBetweenStatements=True ^
/v:CategoryName="Database Maintenance" ^
/v:OwnerLoginName="sa" ^
/v:ReplicatorJobName="JobRunner job replicator" ^
/v:ServerName="(local)" ^
/v:ScheduleName="JobRunner job replicator schedule" ^
/v:RecurringSecondsInterval=10

if %errorlevel% neq 0 (
    echo An error occurred while running sqlpackage.exe
    goto :error
)

:end
exit /b 0

:error
exit /b 1