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 ***
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.sql
):r .\CreateTables_MyDatabase_01.sql
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