0

Excuse me, I generate SQL File with insert command like this

Then, the file contains many lines, and when I open it with Microsoft SQL Server Management Studio, the program can not open it..

How can I run this dump of sql file scripts?

The SQL dump file is large.

Community
  • 1
  • 1
Khaneddy2013
  • 1,301
  • 1
  • 17
  • 25
  • 1
    Define *large* - are we talking about thousands, hundreds of thousands, millions of rows? You should check into `SQLCMD` - the command-line SQL utility for SQL Server – marc_s Oct 29 '14 at 05:45
  • 389 MB it contains 668919 lines, some lines is so long, like html content, and if I open the file using notepad++, it takes some minutes – Khaneddy2013 Oct 29 '14 at 08:47
  • i found this: this case is same with my case: http://stackoverflow.com/questions/20853153/how-to-execute-generated-script-sql-file-with-schema-and-data-in-sql-server-20 – Khaneddy2013 Oct 29 '14 at 08:53

0 Answers0