Cmd - query and export in single file. Sql

Question

I have a folder with several sub-folders containing several arquivos.SQL

I wonder if you have any command of cmd to search and copy to a single file all my files .SQL found.

I was able to do this only by exporting the filenames, but not their content.

Commando:

C:\Users\jefer\Desktop\Integracao>dir /s .sql > todos_scripts.sql

This command lists all the titles of the found files. I would like to copy and export the contents of the files below each other.

I would like to look for a solution of the type below, but using a dir or find and merging results for a single result.

Commando:

C:\Users\jefer\Desktop\Integracao>copy *.sql todos_scripts.sql

Another thing I thought was to unify two commands, but I suppose it’s not possible.

Wrong example:

dir /s .sql | copy *sql listao.sql

Answer 1

Try using for /r loop with copy /b /y listao.sql+"file_in_loop" listao.sql :

>nul cd.2>listao.sql & for /r "C:\Users\jefer\Desktop\Integracao" %i in (*.sql)do copy /y /b .\listao.sql+"%~i" listao.sql

These commands concatenate all your files .sql recursively in a single (list.sql) folder in the current folder.

To specify the location to save the file listao.sql

>nul cd.2>"c:\pasta\salva\listao.sql" & for /r "C:\Users\jefer\Desktop\Integracao" %i in (*.sql)do copy /y /b "c:\pasta\salva\listao.sql"+"%~i" "c:\pasta\salva\listao.sql"

Obs.: Save your file listao.sql in a different folder/sub-folder from where the loop will go, thus avoiding duplication of cumulative copies during processing.