Clarity Service Management

Expand all | Collapse all

easy migration of wspcol & wsptbl

  • 1.  easy migration of wspcol & wsptbl

    Posted 10-16-2018 12:44 PM

    Hi everyone,

     

    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. 

     

    Best Regards,

    Utku



  • 2.  Re: easy migration of wspcol & wsptbl

    Posted 10-16-2018 05:09 PM

    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.



  • 3.  Re: easy migration of wspcol & wsptbl

    Posted 10-16-2018 10:32 PM

    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.



  • 4.  Re: easy migration of wspcol & wsptbl

    Posted 10-17-2018 08:04 AM

    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