How to export data into SQL Azure database
- From Management Studio right-click on the database you'd like to export data from
- Go to Tasks -> Export Data
- Select your source database - regular SQL Server 2008 or 2012
- For the destination database (your Azure database), select .NET Framework Data Provider for SQL Server
- 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
- Click on Next and select the tables you are looking to import into SQL Azure
No comments:
Post a Comment