How to Split Table Structure into Several Parts

Sometimes when migrating from one database to another, we may face the situation when in the source database there is a table with a greater number of columns than the maximum number of columns allowed in the target database. Or according to the optimization process you decided to split a table into several tables.

Using the Ispirer SQLWays Wizard tool you can do that in two ways:

• Using the Queries
• Using the Local Data Type Mapping

To spit a table into several tables using SQWLays Wizard you need to choose “Use Query” on the “Objects Selection” page:

Then you need to specify select queries in the “Select Statement” column and target table names in the “Target Table Name” column. Queries will be used to extract data from appropriate columns from a table and our tool will automatically generate correct definition with the columns that are used in the column list in the select statement. Thus a table name for a new table will be taken from the second column. Please see the screenshot for your reference:

You can specify as many queries as you need, just use “Add Query” for that purpose.

To split a table into several tables using the local data type mapping, please, click on the required table on the “Conversion Options” page and uncheck the columns that should be removed from the conversion and run the conversion. The way it should be done is on the screenshot:

As soon as the first part of the table is migrated, you will need to run the tool once again and specify another set of columns that should be included in the second part of the table:

And also you will have to select the higher level of object and change objects names during the migration before conversion performing:

So to divide a table into several tables you can use queries or check required column in the local data type mapping.

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