sql server - Import data into tables from an SQL file -

sql server - Import data into tables from an SQL file -

i want move info 1 db another. both source , destination database servers aren't connected cannot tasks export destination tables, far have done following.

1) tasks/generate scripts, scheme only, generated sql.

2) went destination db , opened sql file , created database schema.

3) went source database , did tasks /generate scripts time info alternative , generated sql data.

4) went destination db , tried opening sql info script of size 1.4 gb @ point getting error exception of type out of memory.

how can import info sql file?

i getting same issue , solution insert go statement every 100 lines in script file. achieved 1 line of powershell so:

gc script.sql | % {$i=0}{$i++;$_ + $(if($i % 100 -eq 0){"`ngo"}else{''})} set-content mew_script.sql

sql-server sql-server-2008