Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer SQL Server to Oracle Migration overview.

Ispirer SQLWays Database Migration Software

Conversion of Microsoft SQL Server Functions Returning Part of String to Oracle

a) Converting the RIGHT function.

SQLWays converts the Microsoft SQL Server RIGHT function to the Oracle SUBSTR function with negative length parameter.

TABLE 59. Converting RIGHT function

Microsoft SQL Server	Oracle
RIGHT (`ABCDEF',5)	SUBSTR (`ABCDEF',-5);

b) Converting the LEFT function.

SQLWays converts the Microsoft SQL Server LEFT function to the Oracle SUBSTR function with the start position 1 and the same length as defined in the LEFT function.

TABLE 60. Converting LEFT function

Microsoft SQL Server	Oracle
LEFT (`ABCDEF',5)	SUBSTR (`ABCDEF',1,5);