开发者

Large .sql files

开发者 https://www.devze.com 2023-03-07 06:44 出处:网络
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 e

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 freez开发者_JS百科es when copying 10k lines.

Any thoughts how I can split it up?


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

0

精彩评论

暂无评论...
验证码 换一张
取 消