E-MSSQL: After Migrating From Oracle Database to Microsoft SQL Server. The Metadata SQL (Metsql) Has Not Adapted to the New Database Platform and Still Retains Oracle-specific Syntax. (Doc ID 3075263.1)

Last updated on MARCH 04, 2025

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.60 and later
Information in this document applies to any platform.

Goal

After migrating from Oracle Database to Microsoft SQL Server. The metadata SQL (metsql) does not adapted to the new database platform and still retains Oracle-specific syntax.

For instance, %like command dynamically change the concatenation operator '||' (used in Oracle) has not been replaced with the '+' operator required for SQL Server.

Solution

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Goal

Solution

References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

E-MSSQL: After Migrating From Oracle Database to Microsoft SQL Server. The Metadata SQL (Metsql) Has Not Adapted to the New Database Platform and Still Retains Oracle-specific Syntax. (Doc ID 3075263.1)

Applies to:

Goal

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!