1 | Azure Link Setup

 

This article elaborates on creating a database in the azure portal and setting the job for Azure in Bepoz system.

Microsoft Azure is a growing collection of integrated cloud services—analytics, computing, database, mobile, networking, storage, and web—for moving faster, achieving more, and saving money. One of the features is the ability to store SQL Databases.

JobAzurelink.dll is a job in Bepoz that allows databases to be replicated to the Azure cloud.

Before you can set this up, you must have set up a valid Microsoft account with an Azure subscription. To create an account, go to https://azure.microsoft.com/ and follow the instructions.

Prerequisites

N/A

---

Creating the Database in the Azure Portal

Please note that the following procedure may incur charges to your Azure account. It is the responsibility of the user to understand the pricing structures of Azure before proceeding with the below

• Go to https://portal.azure.com to log in
• (1) Click the SQL databases menu option
• (2) In the SQL databases toolbar, click the Add button

• Enter the Database name.
• Select the Subscription that will be used for the database.
• Select the Resource group that will be used to manage the database.
• Select the Server that will be used to store the database.
• Select the Pricing tier that will be used for the database.
• Click the Create button.

• Once this done, you are ready to set up the job in Bepoz

---

SQL Configuration

Once the SQL Database has been created via the Azure Portal or By using SSMS (SQL Server Management Studio).

The following SQL scripts need to be run via SSMS in order to create the Bepoz username and password and correct Role Permissions otherwise Database.exe will not be able to update the Azure Database.

--USE [master]

CREATE LOGIN Bepoz WITH PASSWORD = 'Do4safet';

CREATE USER Bepoz FROM LOGIN Bepoz;

exec sp_addRoleMember 'dbmanager', 'Bepoz';

exec sp_addRoleMember 'loginmanager', 'Bepoz'

 

--USE [NameofAzureDatabase]

CREATE USER Bepoz FROM LOGIN Bepoz;

EXEC sp_addrolemember N'db_owner', N'Bepoz'

---

Microsoft Data Migration Assistant

The Free utility from Microsoft allows the Local SQL database to be migrated to the Azure SQL Platform. 

Download Link

Step 1:

• Click the Plus (+) 

• Project Type = Migration

• Project Name = 'Schema and Data'

• Source Server = SQL Server

• Target = Azure SQL Database

• Migration Scope = Schema and data

• Click Create

Step 2:

• Set the Server Name to the local SQL instance

• Click Connect

Step 3:

• Select the Database you would like to Migrate to the Azure Platform 

• Click Next

Step 4:

• Enter the Server Name of your Azure SQL Instance 

• Authentication = SQL Server Authentication 

• Username 

• Password

• Click Connect

• Select the Database in Azure you would like to Migrate the local SQL database too.

Step 5:

• Keep the defaults  

• Generate SQL Script

Step 6:

• Deploy Schema

Step 7:

• Once Schema is deployed, takes about 15 minutes 

• Migrate Data and await for completion

---

Bepoz Job Settings

• Click the DLL Name dropdown and select Jobazurelink.DLL

• In Schedules, click the Add button and press the OK button (This will set the job to run every time SmartController is started).

• Set up the relevant job options.

• Restart Smartcontroller for Azure link to Connect

Job Options