Feb 10 2020 02:25 AM
Feb 20 2020 09:44 PM - edited Feb 20 2020 09:50 PM
@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