GO Live with new URL

Hi, I’m migrating my site with Newspaper theme from dev to live, where it works with other URL, for example:
URL DEV: myportaldev.com.br
URL Live: myportal.com.br

But I find problems to update content inside pages made with tagdiv composer via MYSQL, because the content has strange code where a can’t select and update with sql commands. I can’t select all contents using my URL dev to update with new URL.

Could you help me?

Hi, I Just used Duplicador, and everything was ok. Only content is beyond this plugin. People use SQL command to select and update all content insiste post and page. I cant because the content is Transformed by tagdiv conposer.l

Catalin,
here is the content I try to explain:
https://www.screencast.com/t/CA5QJ0iDil

And here is the sql commands I need to execute but it don’t find anything:
UPDATE wp_options SET option_value = replace(option_value, ‘Existing URL’, ‘New URL’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;

UPDATE wp_posts SET post_content = replace(post_content, ‘Existing URL’, ‘New URL’);

UPDATE wp_postmeta SET meta_value = replace(meta_value,’Existing URL’,’New URL’);

UPDATE wp_usermeta SET meta_value = replace(meta_value, ‘Existing URL’,’New URL’);

UPDATE wp_links SET link_url = replace(link_url, ‘Existing URL’,’New URL’);

UPDATE wp_comments SET comment_content = replace(comment_content , ‘Existing URL’,’New URL’);

Catalin, I’m the developer who is trying to solve this problem. I’m trying to update content of my client site. The problem is Tagdiv Composer make some “processing” in content pages not letting it readable.
I dont’t need help to make the sql commands, because I know very well it. This commands I put here are very used actually to update posts or pages.
How could you help? It don’t need necessary by sql commands. If only solution is make manually, ok. I need to know, because I will think better before using Tagdiv Composer again.