Hi,
I have tried to migrate events, forms, registrations, transactions etc. from an existing database to a new one, same domain. I installed EE and the add ons I am using on the new site. I moved each table that begins with wp_esp_ and wp_e_ one by one to the new database, then activated the plugins. No joy. What am I missing?
Your missing that many of the entities within EE are custom post types which are then coupled together using our custom tables.
EE events are use a custom post type within WordPress to allow you to use the standard ‘post’ features within WP but then we link all of the event data to that post using the ID within our custom tables.
So to copy EE from one site to another you’ll need to copy all tables and then delete the data you don’t need from the copy, copying ‘just’ the EE data isn’t easily doable currently.