Is it possible to run a large SQL file?

Asked By 20 points N/A Posted on -
qa-featured

 

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

 

SHARE
Answered By 0 points N/A #170658

Is it possible to run a large SQL file?

qa-featured

 

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.

 

Login/Register to Answer

Related Questions