Azure Mobile Services: How to Change the Database

Scope

The purpose of this article is to show how to change the database associated with an existing Azure Mobile Service.

Introduction

Azure Mobile Services creates an Azure SQL Database for each Azure Mobile Service, this way the database will be connected with it, as we can see in the following image:

mymenuapp

This article shows how to replace a database with other database instances.

Description

To change the database from an Azure Mobile Service, we need to go the Configure separator from the Azure Mobile Service and at the bottom of the page we will see the following menu:

change database

Clicking "Change Database" we will have the following screen.



That allow you to create a new database, create a free database (if available) and choose an existing database. We must then wait for a while and a new database instance will be related with the Azure Mobile Service as in the following:

changed database

If we apply a refresh, the page will load the data and the connection string used to connect to the database will be updated, as we can see in the following image:

connection string