Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
2 Antwoorden
4931 Weergaven

Is there any way to copy only master data (partners, products, etc or data of a specific model) completely from one db to another. On development I will need some master data to create sales, invoices, etc. At some point I want to have a fresh db without sales and invoices, but with master data in.

Shure, I can keep a copy of db only with masters but during testing in running db I propably add data to masters that I want to copy to another db.

Avatar
Annuleer
Beste antwoord

Hi

Refer this link may help you:

http://stackoverflow.com/questions/14826862/how-to-restore-a-single-table-from-a-sql-postgresql-backup

http://www.postgresql.org/docs/current/static/app-pgdump.html

http://stackoverflow.com/questions/14826862/how-to-restore-a-single-table-from-a-sql-postgresql-backup

http://stackoverflow.com/questions/14826862/how-to-restore-a-single-table-from-a-sql-postgresql-backup

Avatar
Annuleer
Beste antwoord

Peterm,

If you want to use these master data, you should either keep them at module (by code) level so easily they are usable for other DBs.

In other case, you should export those data and keep them in import-compatible CSVs, so they are easily re-usable.

Thanks.

Avatar
Annuleer
Gerelateerde posts Antwoorden Weergaven Activiteit
9
mrt. 24
118879
1
jun. 20
12110
2
mrt. 16
10414
2
mrt. 15
5060
2
mrt. 15
9984