Hi,

There is nothing that you have to do.  SQLAzureMW is a two part process. The first part exports the schema and data. The second part runs the TSQL generated by part 1 and the BCP commands against SQL Azure. You should be able to just hit the next button after everything is generated to select the target server. As a side note, the BCP command above is not complete. The second part of the process is when you identify the target server and then SQLAzureMW will insert the target server name into the BCP command completing the command.

Let me know if you have other questions.

Take care,

George

Here is a quick video that walks you through SQLAzureMW: http://channel9.msdn.com/posts/SQL-Azure-Migration-Wizard-Part-2-Using-the-SQL-Azure-Migration-Wizard

hi ghuey,

I was successful in migrating the data along with the tables. I used the command prompt to do it. Here is what i did.

bcp [DatabaseName].[dbo].[TableName] in [.DAT file full path] -S tcp:[ServerName].database.windows.net, 1433(this number signifies which database you are using only if there are more than 2 databases in your account OR you can just stop at .net if you have only one database) -U [UserName of the Azure database]@[ServerName] -P [Password of the Azure database] -E -n -b 10000 -a 16384

The above code copied data for all the tables from on-premise computer to the Azure database.

Thank you very much for your time

Sandeep