Â
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
Â
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.
Â