Getting started with single databases in Azure SQL Database
A single database is fully managed PaaS database as a service (DbaaS) that is ideal storage engine for the modern cloud-born applications. In this section, you will learn how to quickly configure and create a single database in SQL Database.
In this section, you will see an overview of available articles that can help you to quickly get started with single databases. The following quickstarts enable you to quickly create a single database, configure a database server firewall rule, and then import a database into the new single database using a
- Create a single database using the Azure portal.
- After creating the database, you would need to secure your database by configuring firewall rules.
- If you have an existing database on SQL Server that you want to migrate to Azure, you should install Data Migration Assistant (DMA) that will analyze your databases on SQL Server and find any issue that could block migration to the single database deployment option. If you don't find any issue, you can export your database as
.bacpacfile and import it using the Azure portal or SqlPackage.
Automating management operations
You can use PowerShell or the Azure CLI to create, configure, and scale your database.
- Create and configure a single database using PowerShell
- Create and configure a single database using Azure CLI
- Update your single database and scale resources using PowerShell
- Update your single database and scale resources using Azure CLI
Migrating to a single database with minimal downtime
These quickstarts enable you to quickly create or import your database to Azure using a
.bacpac file. However,
.dacpac files are designed to quickly move databases across different versions of SQL Server and deployment options within Azure SQL Database, or to implement continuous integration in your DevOps pipeline. However, this method is not designed for migration of your production databases with minimal downtime, because you would need to stop adding new data, wait for the export of the source database to a
.bacpac file to complete, and then wait for the import into Azure SQL Database to complete. All of this waiting results in downtime of your application, especially for large databases. To move your production database, you need a better way to migrate that guarantees minimal downtime of migration. For this, use the Data Migration Service (DMS) to migrate your database with the minimal downtime.. DMS accomplishes this by incrementally pushing the changes made in your source database to the single database being restored. This way, you can quickly switch your application from source to target database with the minimal downtime.
Hands-on learning modules
The following Microsoft Learn modules help you learn for free about Azure SQL Database.
- Provision an Azure SQL database to store application data
- Develop and configure an ASP.NET application that queries an Azure SQL Database
- Secure your Azure SQL Database
- Find a high-level list of supported features in Azure SQL Database.
- Learn how to make your database more secure.
- Find more advanced how-to's in how to use a single database in Azure SQL Database.
- Find more sample scripts written in PowerShell and Azure CLI.
- Learn more about the management API that you can use to configure your databases.
- Identify the right Azure SQL Database/Managed Instance SKU for your on-premises database.