I used the Export data wizard found in Microsoft SQL Server Management Studio, to copy data from a Microsoft SQL Server 2012 localdb database to Windows Azure.

  • Connect Microsoft SQL Server Management Studio to your localdb databse.
  • Right click database > Tasks > Export Data…
  • In the source dialog, choose
    • [.Net Framework Data Provider for SqlServer]
    • [Integrated Security = True]
    • [Data Source = (localdb)\V11.0]
    • [Initial Catalog = Your_Database]
    • [User Instance = True]
  • In the destination dialog, choose:
    • [.Net Framework Data Provider for SqlServer]
    • [Integrated Security = False]
    • [Data Source = yourdatabaseserver.database.windows.net]
    • [Initial Catalog = Your_Database]
    • [Password = YourPassword]
    • [User ID = YourUserId]
    • [User Instance = False]

 

 

Screendumps

 

image

image

image

 

image

image

image

 

NOTE

For an initial start of a project on Windows Azure I used the [Deploy Database to SQL Azure…] wizard:

 

image

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.