The Azure portal provides you with a straightforward way to create a SQL database. As shown in the following screenshot, click on the Create a new database button which will open another screen to ask you to enter the database name, target server, pricing tier, and so on:
Clicking on the Target server option will navigate you to a different screen which will ask you to create a new DB server, if it is not already created. As shown in the following screenshot, click on the Create a new server button to open the New Server form where you need to enter details about the DB server.
Enter Server name, which must be globally unique, as it will create the DB server under the database.windows.net domain. Enter the other fields such as Server admin login, Password, Location and click on the Select button to continue. This will create the server and provision it, so that you can access the hosted DB server:
The next screen will ask you to create the Table API. You will need it to store your data to the backend. Pick the backend language from the list. You can either select Node.js or C#. Let's select Node.js as the language.
Now, click the checkbox to acknowledge the settings confirmation to overwrite the site content. Click on Create TodoItem table to continue. The TodoItem table is a sample DB table that the wizard will generate but if you want to create any additional tables later, you can navigate to the Easy Tables settings:
When it successfully generates a table inside your database, it will show you a green check mark beside the two settings, as shown in the following screenshot:
This confirms that the database has been successfully configured to use. Scroll down to view the third section, where it will generate you the configuration settings and a sample model for you to start the integration part in your application.
If you are creating the application from scratch, the Create a new app tab will provide you a sample Visual Studio project to kick-start. If you have an existing application and/or you want to manually insert the API configurations, navigate to the Connect an existing app tab page, as shown in the following screenshot:
Take a note about the highlighted section, which we will need later to create the MobileServiceClient to integrate the mobile service in our project. The TodoItem model has also been generated for you to easily start with it for the first time.