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.
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
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.