Data Express – How to switch off/on indexes and constraints during masking process

Problem:

     During the masking process sometimes it is needed to switch off/on indexes and constraints in the target database, then after populating the target environment using Data Express to create the indexes and constraints again. This method can be used to improve performance.

Resolution: 

    You may  switch  off/on indexes and constraints using DROP/ADD CONSTRAINT commands  in one of the following ways:     

-        Specify the ALTER TABLE  DROP/ADD CONSTRAINT  commands in the  PRE and POST SQL scripts.

-        Create a specific masking routine to manage this situation and to be responsible to change the PRE and POST SQL scripts, inserting the ALTER TABLE DROP/ADD CONSTRAINT  commands into these files during the masking process.

-        Execute manually two bat files with ALTER TABLE DROP/ADD CONSTRAINT commands. The one bat file before DXESTART with the ALTER TABLE DROP CONSTRAINT  commands and another bat file after DXESTART with the ALTER TABLE ADD CONSTRAINT commands.