Home

Oracle to az sql conversions

%3CLINGO-SUB%20id%3D%22lingo-sub-1163825%22%20slang%3D%22en-US%22%3EOracle%20to%20az%20sql%20conversions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1163825%22%20slang%3D%22en-US%22%3EHey%20guys%2C%20I%20have%20around%2015%20TB%20on-prem%20oracle%20data%20which%20I%20need%20to%20migrate%20to%20azure%20SQL.This%20data%20will%20double%20in%20each%20coming%20year.%20Pls%20suggest%20me%20which%20one%20I%20should%20select%20az%20SQL%20Vm%20or%20azure%20data%20warehouse%3F%20Considering%20cost%2C%20security%2C%20performance%20and%20migration%20easiness.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1163825%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMigration%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1186103%22%20slang%3D%22en-US%22%3ERe%3A%20Oracle%20to%20az%20sql%20conversions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1186103%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F551653%22%20target%3D%22_blank%22%3E%40Goldy777%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHave%20you%20managed%20to%20change%20the%20schema%20to%20SQL%20database%3F%20I%20suggest%20to%20use%20tools%20like%20SSMA.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fssma%2Fsql-server-migration-assistant%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fssma%2Fsql-server-migration-assistant%3Fview%3Dsql-server-ver15%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1186112%22%20slang%3D%22en-US%22%3ERe%3A%20Oracle%20to%20az%20sql%20conversions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1186112%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F551653%22%20target%3D%22_blank%22%3E%40Goldy777%3C%2FA%3E%26nbsp%3BFor%20cost%20and%20performance%2C%20i%20think%20it%20depends%20on%20your%20usage.%20DW%20should%20good%20for%20reading%2Fbrowsing%2Faggregation%20vs.%26nbsp%3B%20VM%20good%20for%20the%20transactions%20from%20write%20and%20update%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20also%20check%20out%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdatamigration.microsoft.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdatamigration.microsoft.com%2F%3C%2FA%3E.%20Have%20you%20managed%20to%20migrate%20the%20Oracle%20schema%20to%20SQLServer%3F%20Take%20a%20look%20at%20SSMA.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fssma%2Fsql-server-migration-assistant%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fssma%2Fsql-server-migration-assistant%3Fview%3Dsql-server-ver15%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
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
Highlighted

@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