/
AstroJohn
/
MailRobot
Обзор
Документация
Войти
/
AstroJohn
/
MailRobot
Код
Запросы
0
Задачи
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
DBProject/runsqlcmd.cmd
17 строк
975 B
AstroJohn
1st commit
11 сен 2024, 13:31
11 сен 2024, 13:31
0f57dc5
Код
Авторство
О чём код?
@echo off rem set sqlscriptpath="c:\Users\John\Documents\SQL Compare\SQL Scripts\localSQLEXPRESS.VHF-ACTIVITY-2017-localSQLEXPRESS.VHF-ACTIVITY-2016-20170918-1324.sql" set sqlscriptpath="c:\Users\John\Documents\SQL Compare\SQL Scripts\alter.sql" set sqllogpath="c:\Users\John\Documents\SQL Compare\SQL Scripts\Logs\result.txt" set sqlbackupcommand="exec run_all @BackupOnly = 1" set dbnamesquery="set nocount on;select name from sys.databases where name like 'SPB-OPEN-VHF%%' Or name like 'VHF-ACTIVITY%%' Or name like 'TWO-CAPITALS%%' Or name like 'RF-CHAMP%%' Or name like 'LO-OPEN-VHF%%' Or name like 'ALRS-UA1DZ-CUP%%' order by name" sqlcmd -S RK1AA_HOME\SQLEXPRESS -U sa -P kb2wkd -Q%dbnamesquery% -h -1 > tmp.txt for /f "delims== tokens=1" %%G in (tmp.txt) do ( echo %%G sqlcmd -S RK1AA_HOME\SQLEXPRESS -U sa -P kb2wkd -d %%G -i %sqlscriptpath% >>%sqllogpath% sqlcmd -S RK1AA_HOME\SQLEXPRESS -U sa -P kb2wkd -d %%G -Q %sqlbackupcommand% >>%sqllogpath% ) del tmp.txt