Home  Home  Home  Kontakt  Kontakt  Kontakt  Inhalt  Inhalt  Inhalt  Blog  Blog  Blog  FAQ  FAQ  FAQ

Deployment mit sqlcmd.exe

Basis Config

rem ##########################################################################
rem set config
set DB_SERVER=VM-WIN7
set DB_INSTANCE=\SQLEXPRESS
set DB_ENV=DEV3
set DB_PFX=DEV

set SQLCMD=sqlcmd.exe
set SQLCMD_OPT=-w 9999 -W -R -k 1 -l 12 -e
set SQLCMD_DBA_AUTH=-E
rem set SQLCMD_DBA_AUTH=-U DBA -P ***
set SQLCMD_AUTH=-E
rem set SQLCMD_AUTH=-U me -P ***

Deploy Batch

rem ##################################################
rem MyDatabase
 
cd  %~dp0/../MyDatabase/100_database/
%SQLCMD% -S %DB_SERVER%%DB_INSTANCE% %SQLCMD_DBA_AUTH% %SQLCMD_OPT% -i deploy.sql -o log/deploy.log
cd  %~dp0/../MyDatabase/200_schemas
%SQLCMD% -S %DB_SERVER%%DB_INSTANCE% %SQLCMD_AUTH% %SQLCMD_OPT% -d %DB_PFX%_MyDatabase_01 -i deploy.sql -o log/deploy.log
cd  %~dp0/../MyDatabase/300_tables
%SQLCMD% -S %DB_SERVER%%DB_INSTANCE% %SQLCMD_AUTH% %SQLCMD_OPT% -d %DB_PFX%_MyDatabase_01 -i deploy.sql -o log/deploy.log

Deploy Script (deploy.sql)

:r .\CreateTables_MyDatabase_01.sql

Ausbau dann z.B. so:

deploy.sql:

:r .\utl_log.010_deploy.sql

utl_log.010_deploy.sql:

:r .\utl_log.200_schema.sql
:r .\utl_log.300_tabs.sql
:r .\utl_log.310_synonym.sql
:r .\utl_log.020_refresh.sql

refresh.sql:

:r .\utl_log.020_refresh.sql

utl_log.020_refresh.sql:

:r .\stubs.sql
:r .\utl_log.400_sp_private.sql
:r .\utl_log.500_sp_public.sql
:r .\utl_log.900_test.sql