Setting up - Microsoft SQL Server on Amazon EC2
PrerequisitesPrerequisites for replatforming to an existing EC2 instance
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Setting up

This section covers the steps necessary to run the Windows to Linux replatforming script.

Prerequisites

In order to run the Windows to Linux replatforming assistant for Microsoft SQL Server Databases script, you must do the following:

  1. Install the Amazon PowerShell module

    To install the Amazon PowerShell module, follow the steps listed in Installing the Amazon Tools for PowerShell on Windows. We recommend that you use PowerShell 3.0 or later for the backup script to work properly.

  2. Install the Windows to Linux replatforming assistant PowerShell backup script
  3. Add an Amazon user profile to the Amazon SDK store

    To add and configure the Amazon user profile, see the steps listed in Managing Profiles in the Amazon Tools for PowerShell User Guide. Set the following IAM policy for your user profile. 

    {
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "VisualEditor0",
      "Effect": "Allow",
      "Action": "iam:PassRole",
      "Resource": "arn:aws:iam::123456789012:role/DevTeam*"
    },
    {
      "Sid": "VisualEditor1",
      "Effect": "Allow",
      "Action": [
        "ec2:RebootInstances",
        "ssm:SendCommand",
        "ssm:GetAutomationExecution",
        "ec2:DescribeInstances",
        "ssm:ListCommands",
        "ec2:CreateTags",
        "s3:CreateBucket",
        "ec2:RunInstances",
        "s3:ListBucket",
        "ssm:GetCommandInvocation",
        "s3:PutEncryptionConfiguration",
        "ec2:DescribeImages",
        "s3:PutObject",
        "s3:GetObject",
        "ssm:StartAutomationExecution",
        "ssm:DescribeInstanceInformation",
        "s3:DeleteObject",
        "ssm:ListCommandInvocations",
        "s3:DeleteBucket",
        "ec2:DescribeInstanceStatus"
      ],
      "Resource": "*"
    }
  ]
}
  4. Create an IAM instance profile role

    To create an IAM instance profile role in order to run Systems Manager on EC2 Linux, see the steps listed under Create an IAM instance profile for Systems Manager in the Amazon Systems Manager User Guide.

Prerequisites for replatforming to an existing EC2 instance

To replatform to an existing instance running Microsoft SQL Server 2017 on Linux, you must:

  1. Configure the EC2 instance with an Amazon Identity and Access Management (IAM) instance profile and attach the AmazonSSMManagedInstanceCore managed policy.

    For information about creating an IAM instance profile for Systems Manager and attaching it to an instance, see the following topics in the Amazon Systems Manager User Guide:

  2. Verify that SSM Agent is installed on your EC2 instance. For more information, see Working with SSM Agent on EC2 instances for Windows Server in the Amazon Systems Manager User Guide.

  3. Verify that the EC2 instance has enough free disk space to download and restore the Microsoft SQL Server backups.