Before upload new server version or new database script the best practice is to do backup. How it works with Azure SQL Database read below.
Note: You must have SQL Server Management Studio to do next steps.
1. Connect to your SQL Server using Management Studio
2. Click right button on your database and select Tasks -> “Export Data-tier Application …” to create bacpac package with backup of your data.
Go through wizard and get bacpac package which contains schema and data of your DB.
3. Another option to get just schema of your DB is click right button on your database and select Tasks -> “Extract Data-tier Application …”
Go through wizard and get dacpac package which contains just schema of your DB.
Now if something goes wrong you can restore your Azure SQL Database clicking right button on Database folder under your server and select “Import Data-tier Application …” to restore bacpac backup.
Have a nice deployments!