While generating SQL script with SQLAzureMW tool, if failed with an error.

Mar 23, 2013 at 12:42 AM

I tried to use the SQLAzureMW tool to migrate a database to SQL Azure. But while generating SQL script, it threw two errors. As a result, the data were not loaded into SQL Azure even the database schema had been created successfully.

Process started at 3/22/2013 5:30:39 PM -- UTC -> 3/23/2013 12:30:39 AM ...
Using BCP to get data from table [dbo].[Configuration]
bcp.exe "[xxx].[dbo].[Configuration]" out "c:\SQLAzureMW\BCPData\dbo.Configuration.dat" -E -n -S patesttdm -T
System.ComponentModel.Win32Exception (0x80004005): The system cannot find the file specified
at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)
at SQLAzureMWUtils.ScriptDatabase.DownloadTableData(String table, String bcpArgsOut, String file)

StoredProcedure [dbo].[AddConfiguration] -- Deprecated feature 'Table hint without WITH' is not supported in this version of SQL Azure.
Mar 23, 2013 at 7:10 PM

Right off, it does not look like BCP.exe can be found. If you bring up a command window and type "BCP -v" what do you get? Note that in SQLAzureMW.exe.config file, you can specify the full path of bcp.exe. Also note that you need to run SQLAzureMW on SQL Server 2008 R2 SP1 or greater.

Let me know if that does not work.