-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathdeploy-dockerenv.cmd
102 lines (89 loc) · 2.81 KB
/
deploy-dockerenv.cmd
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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
@echo off
set SQLPACKAGE_ROOT=%~dp0.sqlpackage\
set PATH=%SQLPACKAGE_ROOT%;%PATH%
if not exist "%SQLPACKAGE_ROOT%\sqlpackage.exe" (
call restore.cmd
)
set TARGET_SERVER=localhost,2500
set DATABASE_NAME=master
set SOURCE_FILE=.\src\MasterDB.Build\bin\Release\netstandard2.0\MasterDB.dacpac
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 ^
/TargetUser:sa ^
/TargetPassword:MssqlPass123 ^
/p:IgnoreWhitespace=True ^
/p:IgnoreSemicolonBetweenStatements=True ^
/v:CategoryName="Database Maintenance" ^
/v:OwnerLoginName="sa" ^
/v:ReplicatorJobName="JobRunner job replicator" ^
/v:ServerName="(local)" ^
/v:RecurringSecondsInterval=10
if %errorlevel% neq 0 (
echo An error occurred while running sqlpackage.exe
goto :error
)
set TARGET_SERVER=localhost,2600
set DATABASE_NAME=master
set SOURCE_FILE=.\src\MasterDB.Build\bin\Release\netstandard2.0\MasterDB.dacpac
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 ^
/TargetUser:sa ^
/TargetPassword:MssqlPass123 ^
/p:IgnoreWhitespace=True ^
/p:IgnoreSemicolonBetweenStatements=True ^
/v:CategoryName="Database Maintenance" ^
/v:OwnerLoginName="sa" ^
/v:ReplicatorJobName="JobRunner job replicator" ^
/v:ServerName="(local)" ^
/v:RecurringSecondsInterval=10
if %errorlevel% neq 0 (
echo An error occurred while running sqlpackage.exe
goto :error
)
set TARGET_SERVER=localhost,2500
set DATABASE_NAME=AdventureWorks
set SOURCE_FILE=.\src\JobRunnerWithDemoData.Build\bin\Release\netstandard2.0\JobRunnerWithDemoData.dacpac
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 ^
/TargetUser:sa ^
/TargetPassword:MssqlPass123 ^
/p:IgnoreWhitespace=True ^
/p:IgnoreSemicolonBetweenStatements=True
if %errorlevel% neq 0 (
echo An error occurred while running sqlpackage.exe
goto :error
)
:end
exit /b 0
:error
exit /b 1