Deploy Database to a Microsoft Azure VM Create a Azure SQL Virtual Machine by logging on to https://manage.windowsazure.com Click on [CREATE A VIRTUAL MACHINE] Select the SQL Image Select SQL Server from the Image list and choose the right SQL Server version you would like to deploy. I choose SQL Server 2012 Ent.Edition Configure the VM, choose […]
SQL Azure Migration Wizard Tool- Download from CodePlex You can download SQL Azure Migration Wizard Tool- from codeplex Download to local drive and extract it.Select SQLAzureMW Choose Analyze/Migrate (Databases) option
Export – Import Data-tier Application Exporting a deployed data-tier application (DAC) or database creates an export file that includes both the definitions of the objects in the database and all of the data contained in the tables. The export file can then be imported to another instance of the Database Engine, or to Azure SQL […]
How do you take an on-premises database and move it to Microsoft Azure Cloud? You can migrate the On-Premises SQL database to Private Cloud SQL Server or Public Cloud (SQL VMs,SQL Database(Shared)). In this post we are migrating the On-Premises SQL Server database to Azure Shared SQL Server (PaaS). You can do this in 3 […]
In this article we will see how to do SQL Database backup directly to Azure Cloud Storage. Microsoft Introduced URL Backup from on-premises to Azure Cloud Storage with SQL Server 2012 . I assume that you have a container set up in Azure Blob Storage Service. Configuration: Create SQL Server credentials for authentication to the Microsoft Azure Blob […]
Microsoft SQL Server Backup to Microsoft Azure Tool enables backup to Azure Blob Storage and encrypts and compresses SQL Server backups stored locally or in the cloud.
Login to On-Premises SQL Server Instance. Right Click the Databases Folder and select [Import Data-tier Application] Choose Import from Windows Azure Storage Provide the Storage Account information Provide the temporary storage location for file to be downloaded.Provide the location which has enough space (.bacpac filesize + 10%) Specify the target Database Name and file locations
You can export the Azure SQL Database using PowerShell , Azure Portal , Visual Studio,SQL Server Management Studio. In this post i have used PowerShell to export the Azure SQL Database to Azure Storage.(You can also export it to you on-premises local storage) #————————–Create SQL Server Azure Database Context —————————# import-module ‘C:Program Files (x86)Microsoft SDKsAzurePowerShellServiceManagementAzureAzure.psd1’ […]
In this post we will go-over on how to move the Azure SQL Database to Azure VM SQL Database. You cannot backup the the Azure SQL Database by issuing Backup Database Command on version [Microsoft SQL Azure (RTM) – 11.0.9230.80 Mar 10 2015 12:37:14 Copyright (c) Microsoft Corporation] it will prompt the below error […]
In this post we will connect Azure SQL Database using PowerShell. I assume that you have a Azure Database Created using Azure Portal and the login information which was provided at the time of database creation. Import Azure PowerShell Module. import-module ‘C:Program Files (x86)Microsoft SDKsAzurePowerShellServiceManagementAzureAzure.psd1’ Azure SQL Database can only be accessed using SQL […]
There are multiple ways of connecting Azure SQL Server Connect by SQL Server Name Connect by URL Connect by FQDN Connect by server name require you host name configuration changes at your end or you should have your VPC / VPN .You can read more here on the guidelines for Connecting to Azure SQL […]