REM This file installs a version of SqlEventLog for Azure SQL DB
REM SqlEventLog in the chosen server and database.
REM Note that the script does not create these prerequisites:
REM 1) Credential and user for credential.
REE 2) External data source for loopback.

ECHO OFF
SET SERVER=xxxxx.database.windows.net
SET DATABASE=
SET USER=
SET PASSWORD=


SET SQLCMD=SQLCMD -S %SERVER% -d %DATABASE% -I -U %USER% -P %PASSWORD%


REM Now load all the SQL files.
ECHO ON
%SQLCMD% -i slog_schema.sql
%SQLCMD% -i usermessages_tbl.sql
%SQLCMD% -i sqleventlog_tbl.sql
%SQLCMD% -i sqleventlogparameters_tbl.sql
%SQLCMD% -i translate_procid_sp.sql
%SQLCMD% -i log_insert_sp.sql
%SQLCMD% -i loopback_azure.sql
%SQLCMD% -i expand_parameter_sp.sql
%SQLCMD% -i sqleventlog_sp.sql
%SQLCMD% -i catchhandler_sp.sql