I have built a django/satchmo ecommerce site that is beginning to obtain some traffic, and i'm getting an issue because I don't possess a wise way to cope with database changes. After I develop the website on my small local system, I make changes towards the layout and also the DB, which handles the merchandise characteristics.
When I wish to push new developments towards the server, I must overwrite the server database that has details about recent consumers and purchases.
What I wish to do is "merge" the 2 databases together to ensure that new purchases still stay recorded within the database, but that also let me push local changes towards the server.
I'd appreciate any advice. Thanks.