• One easy and free solution is to use a parameterised batch file (there are more elegant solutions), this is just a basic example.

    Save the following as deploy.bat:
    SET FOLDER=%1
    SET SERVER=%2
    SET DB=%3

    for %%f in (%FOLDER%\*.sql) do sqlcmd -S %SERVER% -d %DB% -E -i %%f > %%f.log

    Then Execute the batch file passing 3 parameters
    deploy.bat C:\temp\Scripts MYSQLServer MySQLDB

    Obviously you can (and should) add additonal logic for error handling, but as a start this will do what you need.

    MCITP SQL 2005, MCSA SQL 2012