Migrating to another site

I am wanting to migrate all of my Events and Locations to another website.

I have tried a few ways today but none have gone as well as expected.

I tried the Export > Import tool on WordPress, however it ended up where all of my events were tagged with the wrong locations (I have 850+ events across 150+ locations so don’t really want to have to go through each one and edit the location)

I have then tried to use SQL to move the data over, however the postmeta and primary key clashes make that near-on impossible.

Can anyone help?