Build.cmd

@echo off
cd /d %~dp0
REM:If garbled when running, the following link can help to resolve:
REM:http://www.zkea.net/zkeacms/document/issues
WHERE /Q sqlcmd
IF %ERRORLEVEL% NEQ 0 (
echo sqlcmd Utility is required, please install the tool before you run the command
@pause
start https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility
exit
)
@echo *****************************************
@echo ******** Welcome to use ZKEACMS *********
@echo *****************************************
@echo Documents
@echo http://www.zkea.net/zkeacms/document
@echo -----------------------------------------------------------------------------
@echo Will create the ZKEACMS database
@echo If you want to upgrade your existing database, execute the scripts under "Update" folder
@echo -----------------------------------------------------------------------------
@echo Press Enter to use the default setting
@echo Working directory:%cd%
set /P server=1.Sql Server address (local):
if "%server%"=="" set server=(local)
set /P dataBase=2.Database name (ZKEACMS):
if "%dataBase%"=="" set dataBase=ZKEACMS
set /P dbUserId=3.User name (sa):
if "%dbUserId%"=="" set dbUserId=sa
set /P dbPassword=4.Password (sa):
if "%dbPassword%"=="" set dbPassword=sa

@echo Please wait...
@echo Creating Database %dataBase%
sqlcmd -x -S %server% -d master -U %dbUserId% -P %dbPassword% -b -Q "DROP DATABASE IF EXISTS [%dataBase%]"
sqlcmd -x -S %server% -d master -U %dbUserId% -P %dbPassword% -b -Q "CREATE DATABASE [%dataBase%]"

sqlcmd -x -S %server% -d %dataBase% -U %dbUserId% -P %dbPassword% -b -i "script.sql"
if %ERRORLEVEL% NEQ 0 goto errors

sqlcmd -x -S %server% -d master -U %dbUserId% -P %dbPassword% -b -Q "ALTER DATABASE [%dataBase%] SET READ_WRITE"

@echo -----------------------------------------------------------------------------
@echo Complete
goto done

:errors
@echo -----------------------------------------------------------------------------
@echo Warning, an error occurred during database creation. Please check your configuration and try again.
goto done
:done
@pause