While we are working with customer database we must need to ensure not any activity will work with live data
Welcome!
This community is for professionals and enthusiasts of our products and services.
Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.
Query should execute while working with customer database
This question has been flagged
As a moderator, you can either validate or reject this answer.We should need to trigger below queries after restore customer database into local system or staging server
to inactive automatic action
Update ir_cron set active='false';
To set dummy email address into partner
Update res_partner set mailto:email='dummy@example.com';
To remove UUID key
Update ir_config_parameter set value='backup_db' where key='database.uuid';
To remove outgoing email server
Delete from ir_mail_server;
To remove incoming email server
Delete from fetchmail_server;
to update login_id and password for admin user
update res_users set login='admin' where id=2;
update res_users set password='admin' where id=2;
Your Answer
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up