Table of ContentsPreviousNext

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 Oracle to SQL Server Migration overview.

Ispirer SQLWays Database Migration Software

Conversion of Oracle RECORD Variable to Microsoft SQL Server

Since Microsoft SQL Server doesn't support records as type, SQLWays emulates such functionality through use set of distinct variables. For full substitution record variables SQLWays changes definition of record data type, variable declaration with record type, use record variables and use of internal element of record variables.

At first SQLWays converts declaration of variable with record type to set of distinct declaration with corresponding data types. Number and data types of declaring variables are equal with internal element of sources record variable.

Then SQLWays drops definition of record data type.

After that SQLWays looks for use of record variables and converts them as follow:

Table of ContentsPreviousNext
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.