Use a while loop

The datasource can be changed manually in the production enviroment for the smdl

You can do replication

You can use sqlcmd in the batch

example script:

SET usernamevar=sa

SET pwdvar=DATABASEPASSWORD

SET sernamevar=DATABASESERVER

SET dbnamevar=DATABASENAME

sqlcmd -U %usernamevar% -P %pwdvar% -S %sernamevar%-d %dbnamevar% -i DATABASESCRIPT.sql -o DATABASESCRIPTREPORT.txt