Tools and additional help for database migration

Several tools and technologies for data migration are available. You can use some of these tools interchangeably, or you can use other third-party or open-source tools available in the market.

• AWS Database Migration Service supports both the one-step and the two-step migration processes. To follow the two-step migration process, you enable supplemental logging to capture changes to the source system. You can enable supplemental logging at the table or database level.

• AWS Schema Conversion Tool (SCT) is a free tool that can convert the source database schema and a majority of the database code objects, including views, stored procedures, and functions, to a format compatible with the target databases. SCT can scan your application source code for embedded SQL statements and convert them as part of a database schema conversion project. After schema conversion is complete, SCT can help migrate a range of data warehouses to Amazon Redshift using built-in data migration agents.

• Additional data integration partner tools include:

  • Informatica

  • Matillion

  • SnapLogic

  • Talend

  • BryteFlow Ingest

  • SQL Server Integration Services (SSIS)

For more information on data integration and consulting partners, see Amazon Redshift Partners.

We provide technical advice, migration support, and financial assistance to help eligible customers quickly and cost-effectively migrate from legacy data warehouses to Amazon Redshift, the most popular and fastest cloud data warehouse. Qualifying customers receive advice on application architecture, migration strategies, program management, proof-of-concept, and employee training that are customized for their technology landscape and migration goals. We offer migration assistance through Amazon Database Migration Accelerator, AWS Professional Services, or our network of Partners. These teams and organizations specialize in a range of data warehouse and analytics technologies, and bring a wealth of experience acquired by migrating thousands of data warehouses and applications to AWS. We also offer service credits to minimize the financial impact of the migration. For more information, see Migrate to Amazon Redshift.