I have a large file containing 475k rows (around 120Mb) with postalcode data, which i have downloaded from here [postcodedata.nl](http://www.postcodedata.nl/download/).

I have created a table with EntityFramework and adjusted the SQL query so i would be able to use it in Visual Studio.

When i try to run the query it would run for a short while and output:

> 
> Query completed with errors.
> 
> 
> 

while there are no changes made to the database.

I have tested the same query but with 200 rows and 10k rows and it works fine so i suspect the error message is because Visual Studio doesn't have enough memory to proces it. 

I have tried to use SQL Server Management Studio but when i run the code there i get the following error: 

> 
> Insufficient memory to continue the execution of the program
> 
> 
> 

I have also tried to use the SQLCMD command as suggested on other Questions but using that throws the following error:

> 
> Msg 701, Level 17, State 123, Server DESKTOP-PUMBLDD\LOCALDB#EE17CAEE, Line 5341
>  There is insufficient system memory in resource pool 'internal' to run this query.
> 
> 
> 

I don't understand why this query won't run in Visual Studio since i could run it in PhpMyAdmin and it worked just fine. 

So my question is how can i import these data into my database?