Importing an Azure database (restoring)

The following instructions will assist you restore an Azure database on the https://portal.azure.com/ site.

Pre-requisties

1. You will need a subscription (pay for use)
   
   A subscription by itself does not cost you anything, however, you will need a subscription linked to a credit card to allow you to add paid services.

Create an Azure admin user

- add link -

Restoring a database

To restore a database, with in the Azure portal, Microsoft guidelines are:

https://docs.microsoft.com/en-us/azure/azure-sql/database/database-import?tabs=azure-powershell

1. Add a blob storage account
   
   
2. Add a blob container (geo-redundant)
   
   The document blob container needs to be located the on the same physical server (e.g. Australia South East).
   
   
3. Upload a Insol 6 bacpac file to new folder in your Blob Storage,
   
   Use the Azure storage explorer to connect and create folders.
   https://azure.microsoft.com/en-us/features/storage-explorer/.
   
   
4. Add a SQL Server (not a database)
   
   To add a server:
   
   
   1.  
   2. 
      
      The SQL server is now added.
5. Import a Database
   
   As the server level, click "Import database":
   
   
   
   The import database page appears.
   
   
   
   The above pricing tier is the default. This will be changed.
   
   
6. Update the following fields
   
   Collation - set to "Latin1_General_CI_AS"
   
   Incorrectly accepting the default collation will cause a restore error and result in restoring a blank table structure. See "Collation error" below.
   
   Select backup - Navigate to the .bacpac file uploaded to the blob container folder in step 2.
   
   Pricing tier - set to "DTU - BASIC" or "DTU - Standard"
   
   For small databases < 2GB use the basic setting
   For databases > 2GB use the standard setting
   
   Authentication type - Select "SQL Server"
   
   Server admin - add a 'sa' user name and password. ** Remember these details *
   
   
7. Click OK
   
   The database is now being restored.
   
   Once complete, a restore notification will appear on bell icon on the top tool bar:
   
   
   
   

For Insol6 desktop access, SAAS access and/or InsolDataSync (Banking or Creditors' Portal) access

Drop existing SQL Server Users, and re-Create them to have the required and database access permissions from scripts supplied by Support.

Scripts to be provided by Support:

1. AzDB_DropAll_InsolUserObjects
2. Insol2_User
3. InsolSAAS_User
4. 050InsolDataSyncInstallAzureStep02

Common errors

• Selecting the wrong collation will cause an error restoring

Database error logs

For progress, completion, success or errors see:

https://portal.azure.com/#blade/Microsoft_Azure_ActivityLog/ActivityLogBlade/queryInputs/%7B%22user%22%3A%22%40me%22%7D

If the notification display the following error, check the collation setting:

Setting up a database back up

On going back up process

One time bacpac export a the conclusion of the initial setup process