How to update all the required tables while Migrating Wordpress Multisite - Single Network

wpmu_migration_sql.txt

//For Primary Blog
UPDATE `wp_options` SET `option_value`='http://www.test.com' WHERE `option_name`='siteurl';
UPDATE `wp_options` SET `option_value`='http://www.test.com' WHERE `option_name`='home';

//For Secondary Blog
UPDATE `wp_2_options` SET `option_value`='http://www.test.com/blog_2' WHERE `option_name`='siteurl';
UPDATE `wp_2_options` SET `option_value`='http://www.test.com/blog_2' WHERE `option_name`='home';
//Repeat the above codes for all the remaining blogs


UPDATE `wp_blogs` SET `domain`='www.test.com', `path`='/' WHERE `blog_id`='1';
UPDATE `wp_blogs` SET `domain`='www.test.com', `path`='/blog_2/' WHERE `blog_id`='2';
//Repeat the above codes for all the remaining blogs


UPDATE `wp_sitemeta` SET `meta_value`='http://www.test.com/' WHERE `meta_key`='siteurl' AND `site_id`=1;
UPDATE `wp_site` SET `domain`='www.test.com', `path`='/' WHERE `id`='1';

//Finally run these queries and then visit http://www.test.com/
//Hurrah.....

//Source:
https://stackoverflow.com/a/26860852/4380588