Forum db:seed on SQL server

edgarsk

posted 10 years ago

Database Eloquent

Last updated 2 years ago.

daareiza

replied 9 years ago

Hi, after 9 months, you have found a solution?, I wrote a little script but I am completely sure that is very ugly :D

DB::transaction(function() use ($dataKeys, $data) {
	$table = 'table';
	foreach ($data as $row) {
		$rowWithKeys = array_combine($dataKeys, $row);
		DB::insert("SET IDENTITY_INSERT  " . $table . "  ON;insert into  " . $table . "  ([column1], [column2], [column3]) values ('" . $rowWithKeys['column1'] . "', '" . $rowWithKeys['column2'] . "', '" . $rowWithKeys['column3'] . "');SET IDENTITY_INSERT  " . $table . " OFF;");
	}
});
DB::commit();