Archive for November, 2010

11/13/10
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: http://msdn.microsoft.com/en-us/library/ms170207.aspx