BCP is an ideal straightforward command prompt driven tool to push data from one table to another similar table. This makes it an excellent tool to carry out data migration from SQL server to SQL Azure. And here is a blog post: Migrating SQL server Data to SQL Azure using BCP << Paras Doshi, i have written to show how we can migrate SQL server data to SQL Azure using BCP tool.