Migrate IBM Netezza to azure synapse analytics

Question

We need to migrate the IBM Netezza data into azure synapse analytics and as of now we have approximate 55TB data is available which need to migrate so should I use the azure synapse pathway tool as per prerequisite.

https://learn.microsoft.com/en-us/azure/synapse-analytics/migration-guides/migrate-to-synapse-analytics-guide?tabs=migratefromNetezza

If yes could you please let me know how time time it works lo take ? Thanks in advance.

Answer 1

Hello @Prashant Chauda ,

Thanks for the question and using MS Q&A platform.

Yes, you can use the Azure Synapse Pathway to migrate IBM Netezza to Azure Synapse Analytics.

How much time does it take?

It depends on multiple factors like pre-migration planning.

After you decide to migrate an existing solution to Azure Synapse Analytics, you need to plan your migration before you get started. A primary goal of planning is to ensure that your data, table schemas, and code are compatible with Azure Synapse Analytics. There are some compatibility differences between your current system and Azure Synapse Analytics that you'll need to work around. In addition, migrating large amounts of data to Azure takes time. Careful planning will speed up the process of getting your data to Azure.

Another key goal of planning is to adjust your design to ensure that your solution takes full advantage of the high query performance that Azure Synapse Analytics is designed to provide. Designing data warehouses for scale introduces unique design patterns, so traditional approaches aren't always the best. While some design adjustments can be made after migration, making changes earlier in the process will save you time later.

Watch how Walgreens migrated its retail inventory system with about 100 TB of data from Netezza to Azure Synapse Analytics in record time.

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.