Is it possible to run a large SQL file?

Asked By elizabeths land 20 points N/A Posted on - 02/02/2013

 

Hi and good day!

 

I have a large database table on a development server.  My question is, is it possible to run a large SQL file? Is there a large SQL file runner tool? Thanks.

Elizabeth Land

 

• Status: Open
• Question Views: 735
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Malone Toby 0 points N/A #170658

Is it possible to run a large SQL file?

 

Hello Elizabeth,

In my opinion if you have so large database then you should try to have that data in .CSV file and then bulk the important one into SQL server. There is a bulk insert command that allows you to load large data volumes into SQL server. The command look something like this:

BULK INSERT dbo.YourTableName FROM 'yourfilename.csv' WITH ( FIELDTERMINATOR =';',ROWTERMINATOR =' |n' )

I think that this should help you with your problem.

 

About Malone Toby

Questions
3

Answers
62

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 02/02/2013
• Question Category: MS SQL Server