SQL Insert data from .sql file to the table with CMD

Question

I want to insert data from an .sql file to my table in SQL. And all that with CMD.

My file contains that line:

INSERT INTO MYTABLE
VALUES (1, 2, 25, 'AK00008GP005L', '2008-04-19 11:31:00', '000', 1, 239.97, NULL, 'GH783MF', NULL, NULL);

It is possible?

Thanks.

I'm using SQL server 2008 R2. My DB name is TRY. My OS is Windows 7. — HaOx
– HaOx, Commented Apr 16, 2012 at 9:07

Ed Harper · Accepted Answer · 2012-04-16 09:27:04Z

9

You can use SQLCMD (as suggested by Sibster). Assuming the file containing the query is called insert.sql, the command in its simplest form (using NT authentication) would look something like:

sqlcmd -S <servername> -E -d <dbname - TRY> -i insert.sql

To use SQL authentication:

sqlcmd -S <servername> -U <username> -P <password> -d <dbname - TRY> -i insert.sql

answered Apr 16, 2012 at 9:27

Ed Harper

21.6k5 gold badges60 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sibster · Accepted Answer · 2012-04-16 09:17:05Z

3

Use the sqlcmd tool from microsoft.

A example here

answered Apr 16, 2012 at 9:17

Sibster

3,2191 gold badge24 silver badges21 bronze badges

Comments

Suraj Rao · Accepted Answer · 2018-10-09 15:08:42Z

2

Try This:

Open a command prompt window.
Type: sqlcmd -S myServer\instanceName -i C:\myScript.sql
Press ENTER.

edited Oct 9, 2018 at 15:08

Suraj Rao

29.7k11 gold badges96 silver badges104 bronze badges

answered Oct 9, 2018 at 14:59

Rafiqul Islam

96111 silver badges14 bronze badges

Collectives™ on Stack Overflow

SQL Insert data from .sql file to the table with CMD

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related