Move WordPress site from Development to Production

WP from Dev to Prod

-- Script to migrate WordPress database from development to production. Thanks Sergio A. Moreyra.

UPDATE wp_options 
   SET option_value = replace(option_value,'http://www.TuSitio.com/desarrollo', 'http://www.TuSitio.com')
 WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts 
   SET guid = REPLACE (guid, 'http://www.TuSitio.com/desarrollo', 'http://www.TuSitio.com/');

UPDATE wp_posts 
   SET post_content = REPLACE (post_content, 'http://www.TuSitio.com/desarrollo', 'http://www.TuSitio.com');

UPDATE wp_posts 
   SET post_content = REPLACE (post_content, 'src=" http://www.TuSitio.com/desarrollo/', 'src=" http://www.TuSitio.com/');

UPDATE wp_posts 
   SET  guid = REPLACE (guid, 'http://www.TuSitio.com/desarrollo', 'http://www.TuSitio.com') 
 WHERE post_type = 'attachment';

UPDATE wp_postmeta 
   SET meta_value = REPLACE (meta_value, 'http://www.TuSitio.com/desarrollo','http://www.TuSitio.com');