Refresh Secondary Productline

The quickest way I found is to:   export schema data with Oracle tools from first productline,  drop the schema owner (which drops all of his tables) in second productline and then import the data with Oracle.  Then create the indexes.  The Oracle datapump utility can also create the indexes or you can with bldoraXXddl. 

I always recommend option 1.

Bill,

What env/platform?

Do you need the code refreshed or just the data?

It sounds like you want a full productline refresh, code and data.

Then I recommend Option 2 in reverse order (i.e. b then a).


John,
Why delete what can be refreshed? Why compile when srgen will do the trick?

Based in Bill's original post, it seemed he needed to refresh product line meta data, code as well as app data. If that is the case, the safer way is to delete first. If not you need to have a comparison step to remove anything on the target that was removed on the source--copying doesn't do that. In addition, when you copy, you don't copy obj's and you should do a full metaload and recompile.

I always do the delete, clean copy method. I can't keep track of what all the consultants were doing and loading in my second/third/fourth prodline.

I agree that a delete presents less room for someone to question things,
especially in LSF. This is probably even more important if the underlying
OS's have a chance to have varying versions of library files, etc... But
even then, if this is a pre-LSF environment we're talking about, you're
fairly safe copying compiled obj code. If you have a few spare hours and
can wait on a compile, then I would compile.



On Thu, Feb 23, 2012 at 2:58 PM, <forums-lsf-s3-sys-admin@lawsonguru.com>wrote:

> [image: LawsonGuru.com Logo] <https://www.lawsonguru.com/> S3 Systems
> Administration Forum Notification A message was posted to a thread you
> are tracking. *RE: Refresh Secondary Productline* Posted by: *Jimmy
> Chiu*
> 02/23/2012 02:48 PM I always do the delete, clean copy method. I can't
> keep track of what all the consultants were doing and loading in my
> second/third/fourth prodline.
>
> ------------------------------
>
> To view the complete thread and reply via your browser, please visit:
>
> https://www.lawsonguru.co...condary-productline/
>
> You were sent this email because you opted to receive email notifications
> when someone posted and/or responded to a message on this forum.
> To unsubscribe to this thread please visit your user profile page and
> change your subscription options.
>
> Thank you,
> LawsonGuru.com
>

Thanks you all - I really need to delete and copy since the metadata may be way out of sync the source code is bad enough to sync manually !!!   Time to delete

As long as you follow the instructions for copying/refreshing a
productline, you will be ok.

On Fri, Feb 24, 2012 at 7:50 AM, <forums-lsf-s3-sys-admin@lawsonguru.com>wrote:

> [image: LawsonGuru.com Logo] <https://www.lawsonguru.com/> S3 Systems
> Administration Forum Notification A message was posted to a thread you
> are tracking. *RE: Refresh Secondary Productline* Posted by: *Bill Fry
> *
> 02/24/2012 07:49 AM Thanks you all - I really need to delete and copy
> since the metadata may be way out of sync the source code is bad enough to
> sync manually !!! Time to delete
> ------------------------------
>
> To view the complete thread and reply via your browser, please visit:
>
> https://www.lawsonguru.co...condary-productline/
>
> You were sent this email because you opted to receive email notifications
> when someone posted and/or responded to a message on this forum.
> To unsubscribe to this thread please visit your user profile page and
> change your subscription options.
>
> Thank you,
> LawsonGuru.com
>