Hi,
I've checked common conversion errors for Oracle Database to SQL Server 2016 migration with SSMA (https://video2.skills-academy.com/en-us/sql/ssma/oracle/messages/o2ss0007?view=sql-server-ver16) however this error is missing 02SS0050, Conversion of Identifier not supported (CHAR, BINARY_INTEGER, BOOLEAN) is not supported. Below you find the details of the error. Can someone help me convert this and show how to convert it so that the procedure ANALYSE_SCHEMA can work and be migrated to the SQL Server 2016 and Data can be migrated?
The Procedure in Oracle DB on Windows 2003 server is doing this:
ORACLE PROCEDURE:
CREATE OR REPLACE
PROCEDURE ANALYSE_SCHEMA
AS
BEGIN
DBMS_STATS.GATHER_SCHEMA_STATS(OWNNAME => 'XYZ', estimate_PERCENT => 10, cascade => TRUE);
END;
The error with SSMA is:
CREATE PROCEDURE ANALYSE_SCHEMA
AS
BEGIN
/*
- SSMA error messages:
- O2SS0050: Conversion of identifier 'DBMS_STATS.GATHER_SCHEMA_STATS(CHAR, BINARY_INTEGER, BOOLEAN)' is not supported.
EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(OWNNAME = 'XYZ', ESTIMATE_PERCENT = 10, [CASCADE] = 1)
*/
DECLARE
@db_null_statement int
END
GO
Thanks.