MIGRATION FROM SQL SERVER TO VERTICAL WITH ALTERYX

Daniel_Jamet_Bais

Esteemed community I need your opinion about the time it would take me to look 2.5TB from Microsof SQL SERVER to VERTICA or to any other base with ALTERYX this is to make a quote

My computer is a server with this processor Inetl Xeon CPU E5-2407 v2 @2.40 GHz (2 procesadores)
RAM 40GB

jgo

Hi @Daniel_Jamet_Bais,

This is a challenging question to answer because there's a lot of environmental variables that Alteryx is unable to influence.

For instance,

• On premise DB's or cloud
• How big/fast is the pipeline from MSSQL to Alteryx and then from Alteryx to VERTICA... how far does the data need to travel
• Are there any limitations on MSSQL that set the amount of records outputted per X (time)
• What's the recommended transaction size for loading to VERTICA

are a few questions that I can think of, but I'm sure there's more.

Someone may have an opinion on how long it would take, but I'd take it with a grain of salt. Best way to estimate would be to do a small scale test (maybe 500MB - 1GB worth of records) and see how long it takes to transfer.

Hope this helps!