ER/Studio Repository on AzureSQL Pre-requisites: Setting the Foundation Before starting, ensure you meet the necessary pre-requisites, including an Azure account and basic understanding of Azure services.
Step 1: Create an Azure Account
Sign up for an Azure account if you don’t already have one. Microsoft offers a free 12-month tier, including access to Azure SQL Database , which can be used to get started.
Step 2: Create a Resource Group
What is a Resource Group? A Resource Group in Azure is a container that holds related resources for an Azure solution.
Steps to Create:
Log in to the Azure Portal. Navigate to “Resource groups” from the navigation pane. Click “+ Create” and follow prompts to set up a new resource group. Choose a region close to your users to minimize latency.
Step 3: Create an Azure SQL Database Steps to Create the Database:
In the Azure portal, click on “Create a resource” and select “ SQL Database .” Fill out the required information:
Subscription : Choose your Azure subscription. Resource Group : Select the resource group you created. Database Name : Assign a name for your database. Server : Create a new server with a unique name, admin login, and location.
SQL Elastic Pool : Select “No” unless you plan to share resources. Compute + Storage : Configure the database pricing tier. Click “Review + create” and then “Create” to provision the database.
Step 4: Configure Firewall Rules Firewall Configuration Steps:
Navigate to your database in the Azure portal. Under the “Security” section, select “Set server firewall.” Add a rule to allow access from your IP address.
Step 5: Connect to Your Database Connection Methods:
Tools : Use Azure Data Studio or SQL Server Management Studio (SSMS) for database management. Connection Strings : Available for various programming languages (e.g., .NET, Java, PHP) in the Azure portal.
Connecting via SSMS:
Use the server name, database name, and credentials created earlier to connect and start working on your database.
Step 6: Install Team Server Core
In the Configurator page, select AzureSQL when prompted. Refer to official documentation for additional guidance.
Please feel free to follow the steps as outlined from our documentation:
Install or Upgrade Team Server and Repository – TeamServer ER/Studio (embarcadero.com)
Conclusion: Simplified Database Management with AzureSQL Azure SQL Database provides a powerful, scalable, and secure solution for database management. Following these steps ensures you can set up, manage, and connect to your database with ease, allowing you to focus on application development and delivering value to users.
