Search code examples
sqlsql-server-2005-express

Large .sql files

Not sure if this really belongs here, so please move it if it doesn't.

I have several very large .sql file that I'm trying to run in SQL Server Studio Express 2005. The problem is that when I try execute, the program says that I don't have enough memory. Splitting it up by hand would be very time consuming because each is over 500k lines, and the my clipboard freezes when copying 10k lines.

Any thoughts how I can split it up?

Solution

  • You could use the sqlcmd Utility with the -i switch.