Oracle to az sql conversions

Copper Contributor
Hey guys, I have around 15 TB on-prem oracle data which I need to migrate to azure SQL.This data will double in each coming year. Pls suggest me which one I should select az SQL Vm or azure data warehouse? Considering cost, security, performance and migration easiness.
1 Reply

@Goldy777 For cost and performance, i think it depends on your usage. DW should good for reading/browsing/aggregation vs.  VM good for the transactions from write and update?

 

Please also check out: https://datamigration.microsoft.com/. Have you managed to migrate the Oracle schema to SQLServer? Take a look at SSMA.

https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-ver15