CODEWITHSUNDEEP
sql-server-2008
gordon613
gordon613

Reputation: 2952

Executing a very large SQL file in Microsoft SQL Server 2008

I am using Microsoft SQL Server 2008. I have a very large text file (a few hundred thousand rows) which contains INSERT statements which I wish to run. What is the best way of executing this file? (I seem to be limited to a few thousand rows within the Management Studio / New Query)

Upvotes: 1

Views: 146

Answers (1)

Oleg Dok
Oleg Dok

Reputation: 21776

  • sqlcmd
  • separate to multiple files relative equal in size and parallel sqlcmd
  • and the best - bulk load from the original datasource

Upvotes: 1

Related Questions