We copied our shop into a development system and made some big changes. Now we are tested everything and would like to update the database with the latest changes from the live system (costumers and orders) so we would switch live and development system. As we made changes to CMS and configuration we can not switch the whole database.
Who can we copy orders and customers from shop to shop?
I found a blog describing this can be done by copying the listed db tables. But as far as I know directly accessing the database is bad. Would this work or is there are better way?