Archive for November, 2010

Fahad Zia

Running large T-SQL files using SQLCMD

Recently I had to export data and schema of one of the databases ,which I did not have direct access to, using sql publishing wizard. The exported file was 400 MB and using SQL Server 2005 I was not able to import all data as it would complain about memory issues opening this file. I had to use SQLCMD -i command to import this file.
More info on how to run sql queries using SQLCMD can be viewed here: