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].

 [We appreciate you sharing this article, scroll down to share on social media and or subscribe to our pop up newsletter form]


Tell a story with data

We help companies make decisions in the most efficient and collaborative way possible through implementation of pragmatic reporting and analytics solutions.

To make a lasting positive impact on your business, a balance of strategy with execution is key in using the ever-advancing technology to grow, digitally transform and harness the cloud.

Sunesis Consulting is here to help, we combine a blend of talented data experts and designers to accelerate your intended outcomes. From Power BI consulting to Intelligent Automation and backed by a recognized leader in cloud- Microsoft Azure, we have the solution to boost your success.


Our Solutions

  • Power BI Consulting
  • Advanced Analytics & AI
  • Master Data Management
  • Customer Analytics
  • Intelligent Automation

Agility with Azure

Technologies to enable you accelerate.

Globally, Microsoft Azure is a recognized leader in both private and public cloud. It’s an open cloud, providing access to over 200 preconfigured services and the choice to use the technologies you want and have already invested in.

With datacenters in more regions than any other cloud provider, Azure provides a global reach with local presence that many businesses and organizations need, allowing them to reduce the cost, the time, and the complexity of operating a global infrastructure while meeting local data residency needs.

Click here to learn what Microsoft Azure can do for you.

We transform businesses

At Sunesis Consulting, our vision is to be the leading business intelligence solution provider in sub-Saharan Africa. ​ We have transformed businesses across the region by providing services that enhance business intelligence through skills development and implementation of pragmatic reporting and analytics solutions. 

Job Openings

From time to time, we publish job openings. Click the button below to learn more:

Pin It on Pinterest