Migrate Custom Post Type with Custom Fields data and parent child order

Question

Hello WordPress community, I'm trying to migrate my one WordPress custom post type data to another WordPress site and I tried to migrate with SQL and WordPress's default export/import function but not working perfectly. The posts are created dynamically and print title with custom field value by shortcode so when I try to import its display duplicate post found.

I also try to export post with SQL, but it's not export custom field data and parent child hierarchy.

SQL -

    SELECT * 
    FROM  `wp_posts` 
    WHERE  `post_type` =  "post type name here"