Importing the dump

Feb 4, 2014 at 4:32 PM
Edited Feb 6, 2014 at 10:30 PM
So, I got the export part working, I'm a little confused on how this file is going to recreate the data.

my sqlserverdump command:
$ sqlserverdump --sql-engine --server-name=<servername> --username=<user> -- password=<pass> --result-file='/c/Backup/Test.sql' <database>
my sqlcmd, in attempt to restore to a test server.
$ sqlcmd -S <servername2>-d <database> -U <user> -P <pass> -i 'C:\Backup\TEST.sql'
Sqlcmd: Error: Scripting error.
What do you guys use to import? The file size is 450m, is this too much for sqlcmd?
Feb 7, 2014 at 8:45 AM
Haven't tried with such a big file, I have successfully used SSMS with smaller files. Nevertheless, I've done some searching for you: if you take a look a the 10th comment under Gulzar Nazim's answer on, he says he's been able to feed sqlcmd a 400Mb file and the 9th comment talks about a "file splitting solution". Maybe would that be a solution for you...