Blog

Migrating Sage Database from Local Hosting To Azure Hosted Instance
Cloud Computing, Sage, Microsoft Azure

Migrating Sage Database from Local Hosting To Azure Hosted Instance

Mar 30, 2020 | Blog, Service |

With work largely moving from the office to home, solutions that help in migrating systems to the cloud are very crucial. Below is a brief tutorial of how to move SAGE Database from local hosting to Azure Hosted Instance.

  1. Provision an Azure account
  2. Set-up a VM with the following configurations:

a) Windows 10/Server based off client preference

b) Provision SQL instance – can be express (which is free) or paid instance

(i) Set-up SA account

c) VM Settings -> Networking -> Inbound Rules -> Add inbound port -> Enable port 1433 under destination port; protocol to be TCP

Microsoft Azure, SageDB

d) VM Settings -> Change IP from Dynamic to Static

  1. Go to local SQL instance and take DB backup of the SAGE Database
  2. Restore said backups to the SQL instance in the VM created in step 2 above
  3. Retrieve SAGE installer and copy it to the VM created in step 2 above and proceed to install
  4. After successful SAGE install in step 5 above, Open SAGE and perform SAGE configuration
  5. On the local machine to access the remotely hosted SQL instance, go to settings and provide the IP of the server and port for SQL which is 1433. From there the local SAGE instance will be pointed to the Azure Hosted SQL instance

We hope you found this useful. For further assistance, contact us on https://sunesiskenya.com/contact/

Note that the above status is not using a secure link. For you to secure a link you need to set up a Virtual Private Network (VPN) link [Keep it here for a future blog post on how to set up a VPN].

Considerations for Dashboard Creation in Microsoft Excel

Considerations for Dashboard Creation in Microsoft Excel

If you are a financial analyst, then you know how important it is to sharpen your dashboard creation skills. Moreover, you may have read our previous articles covering Microsoft Power BI as a great tool for the creation of dashboards or seen our COVID19 Power BI...

read more
How to reduce Customer Churn using Power BI

How to reduce Customer Churn using Power BI

Businesses rely on their ability to gain and retain customers in order to thrive and generate income; but what if a business is losing customers? This should sound an alarm because it will result to reduced profitability, the need for more marketing and re-acquisition...

read more
7 Essential Benefits of Moving Sage to the Cloud

7 Essential Benefits of Moving Sage to the Cloud

If you are an accountant or work in Human Resources or Finance, then you may be familiar with Sage. If you are not familiar with it, Sage is software that simplifies accounting tasks. It is so adaptable it can be used for both simple accounting and complex financial...

read more
10 Key Advanced Microsoft Excel Functions and Formulas

10 Key Advanced Microsoft Excel Functions and Formulas

Any business in this age needs to use an array of software and tools to run efficiently. These tools help to save time and resources in the daily operations by giving on demand results from data analysis. Currently, businesses can choose from a wide range of tools,...

read more

Office Applications

Programming & Database

Get up to 20% off with our

Bundle Offers

Pin It on Pinterest