database - Populating ms sql with sql files -

i have existing database trying keep date on daily basis. daily dump of sql files. batch script below created , populated database first time run it, doesn't work when try update database it.

`@echo off echo %username% started batch process @ %time%  >output.txt   %%f in (*.sql) ( sqlcmd.exe  -s servername -e   -d databasename -i %%f >>output.txt     ) pause` 

is there different command updating database sql files? output get.

hutrc started batch process @ 9:55:12.25 changed database context 'master'. msg 15416, level 16, state 1, server hutrc1-hp, procedure sp_dbcmptlevel, line 67 usage: sp_dbcmptlevel [dbname [, compatibilitylevel]] valid values of database compatibility level 100, 110, or 120. 

what sql file looks like. long. got first few lines.

use [master] go if not exists (select [name] sys.databases name = n'migration') begin create database [migration] collate sql_latin1_general_cp1_ci_as end go exec dbo.sp_dbcmptlevel @dbname=n'migration', @new_cmptlevel=90 

the error message tells precisely problem , (emphasis added):

procedure sp_dbcmptlevel, line 67 usage: sp_dbcmptlevel [dbname [, compatibilitylevel]] valid values of database compatibility level 100, 110, or 120.

examining sql script sp_dbcmptlevel shows uses different value:

exec dbo.sp_dbcmptlevel @dbname=n'migration', @new_cmptlevel=90                                                              ^^ 

you'll need either edit sql script valid compatibility level, or downgrade server version same version source server.