How to export an Azure SQL database?
To export an Azure SQL database, you can use several methods, but all of them require that the database is in a writable state. Since your subscription has reached its limits and the resources are marked as read-only, you will not be able to perform any export operations directly. Here are the common methods to export an Azure SQL database:
- SQLPackage Utility: This command-line utility allows you to export a database to a BACPAC file. You can run it with parameters specifying the database connection and export file location. However, this requires an active connection to the database.
- Azure Data Studio: This tool provides a graphical interface for exporting databases using the SQL Server dacpac extension. Again, this requires the database to be accessible.
- SQL Server Management Studio (SSMS): SSMS includes a wizard for exporting databases to BACPAC files. This also requires a connection to the database.
- Azure Portal: You can export the database directly from the Azure portal, but this method also requires the database to be in a writable state.
Since your database is currently in a read-only state due to the subscription limits, you will need to resolve the subscription issue to regain access to the database before you can export it. Unfortunately, without an active subscription or a way to create a new one, exporting the database will not be possible.
If you regain access to the database, you can follow the methods mentioned above to export it successfully.
Read more here: Source link
