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

Related Posts	Відповіді	Переглядів
After Load Data Demo demo_data	1 черв. 25	1826
creation of company Вирішено company	1 жовт. 24	13242
Not able to create new company in live database in version 15 company	0 жовт. 22	3016
Is possible update value in exist demo data ? Вирішено demo_data	2 бер. 22	13409
Function tag and getitem tag demo_data	2 січ. 18	9346

Це запитання позначене

You never use demo database for business !!!

Enjoying the discussion? Don't just read, join in!