SQL Azure database

We'll now set up a database that will be used by our factory to copy data from. The Wide World Importers sample database is available at: https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0.

A BACPAC is a file that contains database structures and data, similar to a database backup. The difference is that a BACPAC is a snapshot of a database at a specific time. A database backup is much more than that: the database can be restored up to the last few seconds. Also, a database backup can be incremental—that is, contain data and structures since the last backup. A BACPAC always contains all data.

The version we're using is the standard one, as shown in the following screenshot:

We'll now upload the BACPAC to the storage that we created in the previous section:

1. Open Microsoft Azure Storage Explorer and right-click on the adfv2book storage account to create a container called database-bacpac, as shown in the following screenshot:

2. Now, click Upload...