topic Re: Query about Table maintainenance generator in Application Development and Automation Discussions

Query about Table maintainenance generator

Former Member — Wed, 18 Apr 2012 15:31:24 GMT

Hi Guys,

this must be basic but I was not able to find an answer to this, the question is that I want to maintain a table maintanenace for a custom table in dev and move it to production, the concern is that the table itself is already in production and has about a million records, I hope the TM will not disturb those records. Could you please confrim/calrify ?

Thanks a ton

Sameer

Re: Query about Table maintainenance generator

Former Member — Wed, 18 Apr 2012 15:35:08 GMT

It won't change existing records. You can confirm this by exporting to the test environment first.

Rob

Re: Query about Table maintainenance generator

former_member214878 — Thu, 19 Apr 2012 07:37:43 GMT

Hey Sameer,

Definitly it wont change the data, not even single thing will be changed in a table level.

I had same concern with the bank master custom table we created once, I had to give the TM to that, I did it on DEV but was bit curious to move to PRD. I tested with other TEST Tables and then moved TM.

It worked .........

Dont worry, if you still want to try it out,

create one test table on DEV & PRD -> Transport to PRD -> create data on PRD -> Create TM on DEV -> tranport it.

thanks

Re: Query about Table maintainenance generator

SuhaSaha — Thu, 19 Apr 2012 07:58:43 GMT

Ravindra Sonar wrote:
 .... Dont worry, if you still want to try it out, 
create one test table on DEV & PRD -> Transport to PRD -> create data on PRD -> Create TM on DEV -> tranport it ...

I don't think any sane client will permit developers to test on PRD

Re: Query about Table maintainenance generator

former_member214878 — Thu, 19 Apr 2012 08:59:42 GMT

It depends suhas, how smartly u convience .........

Re: Query about Table maintainenance generator

former_member214878 — Thu, 19 Apr 2012 09:05:25 GMT

Actually I wanted to write Quality insted of Production. But Sameer didn't mention about QLT system, he can test there also indeed.