import multiple sql files using cmd mssql

Bongui answered on November 2, 2022 Popularity 7/10 Helpfulness 1/10

answer import multiple sql files using cmd mssql

related mysql cli import multiple sql files

Comment

Create .bat file
for %%G in (*.sql) do sqlcmd /S --server name-- /d --database name-- -E -i"%%G"
pause

Popularity 7/10 Helpfulness 1/10 Language shell

Tags: cmd import shell sql using

Link to this answer
Share Copy Link

Contributed on Mar 20 2023

Bongui

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

for /f %f in ('dir /b c:\sqlbackup\*.sql') do mysql --user=mylogin --password=mypass mydb < c:\sqlbackup\%f

Popularity 6/10 Helpfulness 6/10 Language sql

Tags: sql mysql-cli import

Link to this answer
Share Copy Link

Contributed on Nov 02 2022

Jittery Jackal

0 Answers Avg Quality 2/10