Thursday, April 16, 2015

How to export data into SQL Azure database

  1. From Management Studio right-click on the database you'd like to export data from
  2. Go to Tasks -> Export Data
  3. Select your source database - regular SQL Server 2008 or 2012
  4. For the destination database (your Azure database), select .NET Framework Data Provider for SQL Server
  5. Enter your Azure server name [serverName.database.windows.net], also fill in User ID and Password, Set Encrypt property to True and Integrated Security to False
  6. Click on Next and select the tables you are looking to import into SQL Azure

No comments:

Post a Comment