I just had a problem with importing large amount of binary data into an SQL server 2005 Express database used for a project at work.
It is not a large database in number of tables, views and stuff, but the document table contains pretty much data. The file with insert statements was on 200MB and I had problems importing the script in SQL Server Management Studio. Therefore, I needed a command line tool to do the work for me.
It didn’t take me long to find the correct SQL server syntax:
Open a cmd window
sqlcmd -i c:\temp\script.sql" and press ENTER
It took some time to run, but after a couple of hours and heavy server load, the script completed successfully 🙂