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:
Azure Storage Explorerand right-click on the
adfv2bookstorage account to create a container called
database-bacpac, as shown in the following screenshot:
- Now, click