When you run SQL Server on an Azure virtual machine or an Amazon EC2 instances there are certain weaknesses on these platforms that could cause unstable or poor performance in your databases. To arm yourself against this it is important to collect some information from your on-premises SQL Server before you migrate. This information will… Continue reading Prepare for a SQL Server to Azure or EC2 migration
Category: Amazon RDS
Migrate your SQL Server database to Amazon RDS
This tutorial assumes that you already have your SQL Server Amazon Relational Database Services (RDS) database up and running. You will need the following: 1. Your RDS Endpoint: “trai.cjss4rqkzige.us-east-1.rds.amazonaws.com” in the example below 2. Your Master Username: “sa” in the example below 3. Your password 4. Install SQL Server Management Studio and connect to… Continue reading Migrate your SQL Server database to Amazon RDS