SSMポートフォワーディングを使用してローカルのSSMSからRDS for SQL Serverに接続してみた

aws ssm start-session `
  --target i-xxxxxxxxxxxxxxxxx `
  --document-name AWS-StartPortForwardingSessionToRemoteHost `
  --parameters host="test-sqlserver.xxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com",portNumber="1433",localPortNumber="11433" `
  --profile <プロファイル名>

Starting session with SessionId: botocore-session-xxxxxxxxxx-xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Port 11433 opened for sessionId botocore-session-xxxxxxxxxx-xxxxxxxxxxxxxxxxxxxxxxxxxxxxx.
Waiting for connections...

CREATE DATABASE CustomerDB;
GO

-- サンプルテーブルの作成（顧客情報の例）

CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY IDENTITY(1,1),
    CompanyName NVARCHAR(100) NOT NULL,
    ContactName NVARCHAR(50),
    ContactTitle NVARCHAR(50),
    Address NVARCHAR(200),
    City NVARCHAR(50),
    Region NVARCHAR(50),
    PostalCode NVARCHAR(20),
    Country NVARCHAR(50) DEFAULT 'Japan',
    Phone NVARCHAR(20),
    Email NVARCHAR(100),
    CreatedDate DATETIME DEFAULT GETDATE(),
    UpdatedDate DATETIME DEFAULT GETDATE(),
    IsActive BIT DEFAULT 1
);
GO

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Action": [
                "kms:Decrypt",
                "kms:DescribeKey",
                "kms:GenerateDataKey"
            ],
            "Resource": [
                "arn:aws:kms:ap-northeast-1:<アカウントID>:key/xxxxxxxxxxxxxxxxxxxxxxxxxx"
            ]
        },
        {
            "Effect": "Allow",
            "Action": [
                "s3:ListBucket",
                "s3:GetBucketLocation"
            ],
            "Resource": [
                "arn:aws:s3:::<バケット名>/backups/"
            ]
        },
        {
            "Effect": "Allow",
            "Action": [
                "s3:GetObjectMetaData",
                "s3:GetObject",
                "s3:PutObject",
                "s3:ListMultipartUploadParts",
                "s3:AbortMultipartUpload"
            ],
            "Resource": [
                "arn:aws:s3:::<バケット名>/backups/*"
            ]
        }
    ]
}

USE CustomerDB;
GO

EXEC msdb.dbo.rds_backup_database 
    @source_db_name = 'CustomerDB', 
    @s3_arn_to_backup_to = 'arn:aws:s3:::<バケット名>/backups/CustomerDB.bak',
    @type = 'FULL',                    
    @overwrite_s3_backup_file = 1;     
GO

EXEC msdb.dbo.rds_restore_database 
    @restore_db_name = 'CustomerDB_Restored', 
    @s3_arn_to_restore_from = 'arn:aws:s3:::<バケット名>/backups/CustomerDB.bak',
    @type = 'FULL',              
    @with_norecovery = 0;        
GO

USE CustomerDB_Restored;
GO

SELECT * FROM Customers ORDER BY CustomerID;
GO