AWS DMS Schema Conversion now supports offline SQL Server conversion

AWS Database Migration Service (DMS) Schema Conversion

AWS DMS Schema Conversion now supports offline source conversion for Microsoft SQL Server, allowing you to convert SQL Server schemas and code without direct connectivity to your source databases. This feature extracts metadata using standard database commands in your own environment and uploads it to DMS Schema Conversion for processing, eliminating security reviews, firewall changes, and VPN setup that delay migration projects.

Offline Source is ideal for organizations with security policies that restrict external tool access to production SQL Server databases. Database administrators generate human-readable metadata files within their existing environment, and security teams can review the commands and output before uploading, making approval straightforward. By removing the connectivity requirement, Offline Source transforms weeks of security reviews into a simple command-and-upload workflow.

Offline Source supports all DMS Schema Conversion targets at no additional conversion charge. For regional availability, see the Supported AWS Regions page. To get started, see Using Offline Source in the DMS Schema Conversion documentation.

Source: AWS release notes

If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.