忙裏偷閑

很多事情很多心情寫了也就記下了; 不寫,以後可能就忘了.
個人資料
正文

Removing customer email addresses in non-production environment

(2010-03-16 10:45:12) 下一個

To avoid accidently send emails to customers when we doing the testing in non-production environment, we need to remember to remove the real customer emails when we clone from production.

Here is the query to run:

update HZ_CONTACT_POINTS set email_address = '' where owner_table_id in

   (select party_sites.party_site_id from hz_party_sites party_sites, hz_cust_acct_sites a_bill

   where party_sites.party_site_id = a_bill.party_site_id )

commit;

[ 打印 ]
閱讀 ()評論 (4)
評論
目前還沒有任何評論
登錄後才可評論.