locked
Copy Teradata database to Azure SQL DW RRS feed

  • Question

  • Hi All,

    Please can you provide the complete step to copy Teradata database to Azure SQL DW(Migration)

    As i am new to Azure.

    Thanks,

    Satya


    • Edited by Satya2018 Friday, December 22, 2017 3:58 PM
    Friday, December 22, 2017 3:58 PM

All replies

  • The easiest way is using the Copy Wizard in the V1 ADF service:

    https://docs.microsoft.com/en-us/azure/data-factory/v1/data-factory-azure-copy-wizard

    We are porting that Copy Wizard experience to the new V2 ADF service, but it is not yet released. In the meantime, you can build this using the Copy Activity in V2:

    https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview

    Here is the Teradata connector doc:

    https://docs.microsoft.com/en-us/azure/data-factory/connector-teradata

    Friday, December 22, 2017 7:41 PM
  • I get to know that doing migration from Data factory is not the best practise as there is many issue with Data factory.

    Instead of this need to move teradata to SQL(On premises) and this will happened with the help of SSIS(create package using Data flow control) and Attunity connectors and then there are many ways to move it to Azure SQL DB.

    Please help

    Thanks,

    Satya

    Wednesday, December 27, 2017 11:49 AM
  • I get to know that doing migration from Data factory is not the best practise as there is many issue with Data factory.

    Instead of this need to move teradata to SQL(On premises) and this will happened with the help of SSIS(create package using Data flow control) and Attunity connectors and then there are many ways to move it to Azure SQL DB.

    Please help

    Thanks,

    Satya

    Might be faster if you export to flat files using BTEQ scripts or the fastexport utility from Teradata then upload to SQL DW either manually (azcopy to blob store, polybase load into SQL DW) or use the SSIS SQL DW loader to do the same thing but you get the SSIS interface. Just remember to export to the right data types and format that are supported in SQL DW and polybase so you don't have to do an extra step to clean-up or transform the data. Adding an intermediate SQL Server instance doesn't really add much value and might be slower overall.

    As for Azure Data Factory, please do share your issues in the ADF forum so folks can either help you or the product group can take the feedback to improve the service. Post your ADF issues/feedback at https://social.msdn.microsoft.com/Forums/en-US/home?forum=AzureDataFactory&filter=alltypes&sort=lastpostdesc


    No great genius has ever existed without some touch of madness. - Aristotle

    Wednesday, December 27, 2017 7:37 PM