How to execute generated script(.sql file) with schema and data in SQL Server 2008

SQL Server offers 2 command prompt features that can se used for executing large queries - osql (will be removed in future), and sqlcmd

osql is located in the Tools\Binn subfolder. To execute a SQL script:

1. Start the Command Prompt
2. Navigate to the folder where the osql utility is located
3. Run the command in the following format:
   osql –H <workstation name> -S <server_name[\instance_name]> -U <user login ID> -P <login password> –i <full path to script>

To execute the large.sql file located in the D:\test, against the Central database on the SQL Server instance Dell\SQL2012, as an sa with the 'sqladmin' password, run the following command:

osql -H Dell -S Dell\SQL2012 -i D:\test\large.sql -U sa -P sqladmin

The sqlcmd command line utility is also located in the SQL Server’s Tools\Binn sub-directory. To execute a SQL script:

1. Start the Command Prompt
2. Navigate to the folder where the sqlcmd utility is located
3. Run a command in the following format:
   sqlcmd –S <server name> -d <database name> -i <full path to script> -U <user login ID> –P <login password>

To execute the same as above, run the following command:

sqlcmd -S Dell\SQL2012 -d Central -i D:\test\large.sql -U sa –P sqladmin

Start the sqlcmd Utility Run Transact-SQL Script Files Using sqlcmd