Many Sql scripts to execute

Question

I have 90 scripts in C:\SQL Scripts\*sql how could i execute by command ,i saw many things on net but could execute it successfully,,, I am using sql 2008 R2 , not a default instance

Gohil Jayendrasinh · Answer

Hi Create one common .sql file that contain all the .sql file information like /* BUILD A DATABASE */ -- This is the main caller for each script SET NOCOUNT ON GO PRINT 'CREATING DATABASE' IF EXISTS (SELECT 1 FROM SYS.DATABASES WHERE NAME = 'MSSQLTIPS') DROP DATABASE MSSQLTIPS GO CREATE DATABASE MSSQLTIPS GO :On Error exit :r c:\Scripts\CREATE_TABLES.sql :r c:\Scripts\TABLE_INSERTS.sql :r c:\Scripts\CREATE_INDEXES.sql :r c:\Scripts\CREATE_PROCEDURES.sql PRINT 'DATABASE CREATE IS COMPLETE' GO Then create .bat file like SQLCMD -E -dmaster -ic:\Scripts\create_db.sql PAUSE Then simply Double clicking the .bat file, each script processed and that the database created successfully. For more information http://www.mssqltips.com/sqlservertip/1543/using-sqlcmd-to-execute-multiple-sql-server-scripts/

Many Sql scripts to execute

Answers (1)