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.

Improve this question
3
  • 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 Commented Oct 29, 2014 at 5: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 Commented Oct 29, 2014 at 8:47
  • i found this: this case is same with my case: stackoverflow.com/questions/20853153/… Commented Oct 29, 2014 at 8:53
Related questions
284
How do you import a large MS SQL .sql file?
0
Importing File to SQL Server
35
Best (easiest) way to make a SQL Server dump and import that dump in another SQL Server
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.