Migrating Partitioning

Record and index partitioning is not migrated as part of the IDE project. If you want to migrate the partitioning metadata along with the record, you will need to complete the following tasks:

1. Create an IDE project containing the record or records on the source database.

2. Create a Data Migration project containing the partitioning metadata on the source database and copy the project to file.

3. Copy the IDE project to the target database.

4. Load the Data Migration Project on the target database.

5. Optionally, you can run a compare on the project.

6. Copy the Data Migration project to the target database.

7. In Application Designer on the target database, open the project containing the partitioning and alter the records.

To create the Data Migration project on the Source Database:

1. In PIA for the source database, select PeopleTools, and then Lifecycle Tools, and then Migrate Data, and then Data Migration Workbench.

2. Click the Add a New Value link.

3. Enter a project name and description.

4. Select PTTBLIDXPART as the Data Set Name.

5. The Insert Data Content page will open.

6. Enter the criteria for the record or records containing portioning that you want to migrate and click Search.

   For search options, refer to Lifecycle Management Guide: Defining ADS Project.

7. Select the records that you want to migrate from the Search results.

8. Click the Insert and Return button to insert the selected items.

9. Click OK on the message that the instances were inserted into the project.

10. Click Save

11. Click the Copy to File button.

    Before you can Copy to File, the Project Repository must be defined. Define the same project repository on both the source and target database.

    See Lifecycle Management Guide: Managing ADS Project File Locations.

To load the Data Migration Project on the Target Database:

1. In PIA for the source database, select PeopleTools, and then Lifecycle Tools, and then Migrate Data, and then Data Migration Workbench.

2. Click the Load Project From File link.

3. Select the file to load and click Load.

4. If you want to compare the file:

   1. Click the Compare button.

   2. Click Run on the Compare From File page.

   3. Click OK on the Process Scheduler Request page.

   4. Click OK again to return to the Project.

   5. Click Refresh, when the compare has completed, the compare results will be displayed.

      For details on viewing compare reports see Lifecycle Management Guide: Viewing Compare Reports.

5. Click Submit for Copy.

6. Click Run on the Copy From File page.

7. Click OK on the Process Scheduler Request page.

8. Click OK to return to the project.

9. Click Refresh to verify the copy completed successfully.

To Alter the records in Application Designer:

Note:

The tablespace for the partitioned records must exist on the target database.

1. Open the project in Application Designer on the target database.

2. Open the record.

3. Select Tools, Data Administration, Partitioning.

4. Select Apply Partitioning and click Save.

5. Click OK.

6. If you partitioned on indexes, select Tools, Data Administration, Indexes.

7. Select the Index and click Edit Index DLL.

8. Select Some for platform and deselect Oracle if it is selected.

9. Click OK twice.

10. Save the record.

11. Repeat steps 2 through 10 for each record in the project that contains partitioning.

12. Select Build, Project.

13. Select Alter Tables.

14. Click the Settings button and go to the Alter tab.

15. Select Alter even if no changes and Alter by Table Rename.

16. Set your logging and script options.

17. Click OK.

18. Click Build.

19. Use your SQL tool to view the script and run it.