They are stored in post_content. As far as updating URLs, that depends on what type of field you’re talking about and how you are migrating the database. Some ACF fields store post or term ID values and they will only continue working if the post/term/user IDs are the same.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users