To copy all the files in various subdirectories to a single directory

for /f “tokens=1 delims=~” %i in (‘dir r: /b /S /AD’) do dir /b %i*.sql

use with xcopy /D

Advertisements