how to run all files from a script folder using sql query

Question

In the directory 'C:\scripts' I am having script files in '.sql' format.How to execute all these files at the time using sql query from my SQL SERVER MANAGEMENT STUDIO.

hi, welcome to StackOverflow! Please take the tour here: http://stackoverflow.com/tour — Eduard Uta, Nov 28 '14 at 10:39

score 1 · Answer 1 · edited May 23 '17 at 12:25

1

If this linked post contains the info you need then I suggest marking your post as duplicate of the linked one: Run all SQL files in a directory

Otherwise, check if this helps: http://www.sql-server-helper.com/tips/execute-sql-scripts-batch.aspx

edited May 23 '17 at 12:25

Community

1
1

answered Nov 28 '14 at 10:49

Eduard Uta

2,477
5
26
36

score 0 · Answer 2 · answered Nov 28 '14 at 10:47

0

make a batch file with anyname.bat and save it in the same directory, save it and run it. this sample of mysql

@ECHO OFF

ECHO Running scripts
FOR %%i IN (*.sql) DO mysql -uroot -proot databasename< %%i

ECHO Finished!
pause

answered Nov 28 '14 at 10:47

Sindhoo Oad

1,194
2
13
29

please give query for sql – Saravana Kumar Nov 28 '14 at 10:53
sql is Structured Query Language, it is used to query your database not to run `.sql` files placed somewhere in your system. what is the need to do so? – Sindhoo Oad Nov 28 '14 at 10:57

how to run all files from a script folder using sql query

2 Answers2