title: Transfer SQL Server data to SQL Azure
body: <p>I have a local database SQL Server 2008 Express and I have tables along with data in them. I want to export those schemas and data to SQL Azure database.</p>
  
  <p>What I have tried in SQL Management Studio is to right-click database (contextual menu) and Tasks->Generate Scripts. But those SQL scripts were only the schema, stored procedures etc and no data is exported at all.</p>
  
  <p>Then I have tried Tasks->Export Data, but there were no appropriate export types. I have seen only Flat File dump and I think SQL Mgmt Studio 2008 R2 does not support importing flat files for SQL Azure.</p>
  
  <p>Is there a nicer way to export data from SQL Server as sql scripts and execute them on a remote server without using any 3rd party tools?</p>