SSMA Extension Pack for Oracle not compatible with ODBC 18
Good day, We use SSMA Extension Pack for Oracle on our DB, and upon installation of ODBC 18 Drivers the following error now occurs. From my understanding, this is due to SSMA Extension Pack using older drivers and being forced to connect with encryption due to latest ODBC. So the only way to fix would be for MSFT to update SSMA Extension pack for Oracle. Is this correct? Attached screenshot of the error. Please help advise, thanks.
Migration from Sybase ASE using SSMA CLI
Recently I learned a lesson through multiple testing around SSMA for Sybase. Let’s suppose you need to migrate your data from Sybase ASE to SQL Server. You could use the SSMA GUI tool to connect to both destinations and select schemas or objects to convert and migrate. Now what if you needed to automate this process?Migrating Oracle to SQL Server using SSMA – Error: Cannot find either column "ssma_oracle" or the user-defined function or aggregate "ssma_oracle.rpad_varchar"
First published on MSDN on Oct 19, 2016 Issue:You are trying to migrate server objects and data from Oracle to SQL Server using SSMA for Oracle and for a particular view which has the RPAD function and getting the following error while performing database synchronization.
