How to import sql table into SQL Server in Visual Studio 2013?

Question

ASP.NET

There is a sql table that was unloaded from the same Visual Studio.
Its contents are

INSERT INTO [dbo].[Table] (...) VALUES(...)
...

and there are about 2000 such lines. 8 mb
Therefore, because of the large volume, it is simply impossible to push this into a query to the table through the clipboard. (Out of memory expection, or just does not copy)
When I try to just open the file through the visual and execute the SQL query, I get the "object not found" error. This is most likely due to the fact that the database itself is not selected.
So how do you quickly export/import data to a local SQL Server?
And not a complete dump and restore of the entire database, but import and export of individual tables.

Answer 1

Create many small files and import with bat -name:

@echo off
for /r C:\путь к папке с файлами .sql %%g in (*) do SQLCMD.EXE -d [в какой базе выполнить запросы] -i "%%~nxg" -o "%%~nxg.log"

Or, if the database was created in Visual Studio , then the easiest way would be to simply connect it to SQL Server Management Studio .

Answer 2

start SQL Management Studio and do everything.