I'm going to migrate my system from 14.1.01 to 17.1. But we have a lot of custom tables & columns (more than 750 columns).
We are going to use swingbox method for migration and we have a fresh installed 17.1. Is there any easy way to move these custom columns and tables in new system? I don't want to waste my time by opening the WSP and create one by one.
Do a pdm_extract from the original environment of the wspcol and wsptbl tables and redirect into a file. Then use pdm_userload to load these into the new environment. Now run pdm_wsp and pretend to make a schema change so you can then do a Save and Publish. Finally run pdm_publish to create the tables and columns in the database.
I’ve done this before, this process works well. The one thing I’d add is to remove the last_mod_by column from the load, otherwise it may fail if that user doesn’t exist in the destination system.
Thanks Lindsay_Estabrooks & gbruneau for answers.
I'm going to try your suggestion but my migration environment is down right now
I'll let you and the community know about the result