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.