Project

General

Profile

Download (757 Bytes)

Recreation of tables » recreatetables.bat

Edvīns Liepa, 2021-03-09 14:32

 
@echo off
setlocal EnableExtensions EnableDelayedExpansion

set mastersoft_dir=C:\Mastersoft
set dbadm=%mastersoft_dir%\Deployment\DbAdm\DbAdm.exe
set sysexp=%mastersoft_dir%\Deployment\SysExp\SysExp.exe
set dsn=IPSDATABASE

if "%~1" neq "" (
set dsn=%~1
)

set /p recreate_tables="Enter a comma separated list of tables to recreate: "
if /I "!recreate_tables!" equ "" (
echo No tables specified. Exiting...
exit /b 1
) else (
echo Tables %recreate_tables% of "%dsn%" will be recreated
)

set /p UserAgree=Continue? (y/n):
if /I "%UserAgree%" neq "y" (
goto:eof
)

echo Recreating BOS database tables...

%dbadm% --opts=nokey --dsn=%dsn% --create --force --tables=%recreate_tables%
if ERRORLEVEL 1 goto:eof

echo Tables recreated successfully.
    (1-1/1)