How to remove demo data from an already live and running application?

Question

I need to remove Your company and other demo data from an existing application without affecting the useful records.
The other company data should remain intact only demo data should be removed.

Keyur · Accepted Answer

Hi Sohail,

You should create new database without demo data instead removing demo data from existing database.

Andreas Fuchs · Answer

@avarcas.com Thanks for your answer helped me allot

Avarcas.com · Answer

You can use the following:

*Enter your VPS (if remote) or open terminal if in local:*
ssh -l root 99.99.99.99
*
*
*Use the postgres user:
*
➜  ~ su postgres
*Select database
*
➜ ~ psql abc_db_name
*And fire this operations in terminal:
*
delete from stock_pack_operation; delete from stock_picking; delete from stock_move; delete from account_invoice; delete from account_partial_reconcile; delete from account_move; delete from sale_order;  delete from account_payment;

iWesabe Technologies · Answer

I agree with  Keyur [1] .
**You never use demo database for business !!!
** Deleting demo data through postgres is *Not a proper way.*
Demo data will be restored if you install/upgrade a module.
Find the installed apps in existing database, create new one and install those.
Export all data in CSV/Xls and restore in new database.

[1] https://www.odoo.com/forum/help-1/user/17522

相關帖文	回覆	瀏覽次數
After Load Data Demo demo_data	1 6月 25	864
creation of company 已解決 company	1 10月 24	12461
Not able to create new company in live database in version 15 company	0 10月 22	2194
Is possible update value in exist demo data ? 已解決 demo_data	2 3月 22	12493
Function tag and getitem tag demo_data	2 1月 18	8560

此問題已被標幟

You never use demo database for business !!!

喜歡這則討論？不要只閱讀，加入發表意見吧！