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 يونيو 25	1750
creation of company تم الحل company	1 أكتوبر 24	13194
Not able to create new company in live database in version 15 company	0 أكتوبر 22	2959
Is possible update value in exist demo data ? تم الحل demo_data	2 مارس 22	13333
Function tag and getitem tag demo_data	2 يناير 18	9290

لقد تم الإبلاغ عن هذا السؤال

You never use demo database for business !!!

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!