Database Reference
In-Depth Information
Figure 5.5
Local SQL Server login.
7. In the Documents folder, open the script saved in the previous step. Click !Execute on
the tool bar to create the database Computer_Store on the local SQL Server.
8. To illustrate the process of migrating the database from the local server to Windows
Azure SQL Database, you will need to drop the database Computer_Store from the
Windows Azure Management portal.
9. Open the Windows Azure Management Portal, click the SQL DATABASES node.
Select the database Computer_Store . hen, click DELETE .
10. After the database Computer_Store is deleted from the Windows Azure Management
Portal, open the virtual machine, myserver .
11. Start SQL Server Management Studio . Expand the Databases node to conirm that
the database Computer_Store has been created on the local computer.
12. To migrate the Computer_Store database to Windows Azure SQL Database. Expand
the Databases node and right click on the database Computer_Store . From the drop-
down list, select Ta sk s , and then Deploy Database to SQL Azure . On the Introduction
page, click Next .
13. In the Deployment Settings page, click the Connect button. Similar to Figure 5.3,
enter your Windows Azure SQL Database server login information and click the
Connect button.
14. If the connection is successful, you should be able to see the Deployment Settings
like the one in Figure 5.6. Notice that the temporary database ile has the extension
.bacpac. his indicates that we are using another data migration tool called a DAC,
which will be covered in the next section.
15. To verify that the database is deployed, open the Windows Azure Management portal,
click the SQL DATABASES link. You will see that the Computer_Store database is
created on Windows Azure.
Search WWH ::




Custom Search