Exclude tables while cloning from prod

[kumaran]

Hi Experts,

I want to know the possible ways to exclude certain tables while cloning production data to DEV or TEST.

Few tables have sensitive information and we dont want those tables to be cloned to DEV..

While going through wiki I understood that we have to use 'preserve data' and 'Exclude tables' module and define my tables.

but do it need to define this tables in Prod or dev?

Please help me if anyone used anyother successfull approaches.

Thanks in Advance.

[sergiu_panaite]

It is possible, have a look here:

http://wiki.servicenow.com/index.php?title=System_Clone#gsc.tab=0

7.3 Excluding Tables from Cloning

Regards,

[kumaran]

@Sergiu,

Thanks for your reply.

So I have to defne my table name in both 'preserve data' and 'Exclude table' on target instance, to maintain my old data on target instance(DEV)?

to avoid production data override..

[sergiu_panaite · Accepted solution]

Yes, otherwise you end up with an empty table on the target.

Regards,

[kumaran]

Thanks a lot Sergiu for your quick reply