SQLWays (Beta) Web: Structure Changes

Migration is the best reason for any changes in the database, including refactoring and getting rid of unnecessary objects/data. The tool has a huge number of options that allow you to make automatic changes during conversion.

If you want to shuffle objects according to different schemes, it can be done at the level of objects of each type, both for each schema and for each object separately, as indicated in the screenshot below:

If you want to change the names of objects/columns, you can change them as shown in the screenshot below:

You can also change column types as shown in the screenshot:

Detailed information on data type mapping can be found in the article Data Type Mapping (Local & Global).

In this case, the mapping of schema/object/column names will be taken into account when converting other objects in this scope. If a table used in the source stored procedure is renamed, its name will also be updated in the converted code.

If you did not find a feature or required option, contact us, and we will help you select the best tool configuration.

Database Migration Guide

More Tips and Tricks

If you have any questions or face any difficulties, please contact our support team at support@ispirer.com