This pattern outlines steps for automatically creating AWS CloudFormation templates for AWS Database Migration Service (AWS DMS) using Microsoft Excel and Python.
Migrating databases using AWS DMS often involves creation of AWS CloudFormation templates to provision AWS DMS tasks. Previously, creating AWS CloudFormation templates required knowledge of the JSON or YAML programming language. With this tool, you only need basic knowledge of Excel and how to run a Python script using a terminal or command window.
As input, the tool takes an Excel workbook that includes the names of the tables to be migrated, Amazon Resource Names (ARNs) of AWS DMS endpoints, and AWS DMS replication instances. The tool then generates AWS CloudFormation templates for the required AWS DMS tasks.
For detailed steps and background information, see the blog post Create AWS CloudFormation templates for AWS DMS tasks using Microsoft Excel in the AWS Database blog.
