{"id":547,"date":"2014-05-27T13:08:07","date_gmt":"2014-05-27T11:08:07","guid":{"rendered":"http:\/\/dety.net.ua\/?p=547"},"modified":"2014-05-27T13:08:07","modified_gmt":"2014-05-27T11:08:07","slug":"migration-steps-for-iis-7-5-and-mssql-2012","status":"publish","type":"post","link":"https:\/\/dety.net.ua\/?p=547","title":{"rendered":"Migration steps for IIS 7.5 and MSSQL 2012"},"content":{"rendered":"<p><strong>IIS<\/strong><\/p>\n<p>You have to install Microsoft Web Deployment Installer 4.5 and the modules below for IIS migration.<\/p>\n<p>Then you can choose from the server menu (right side) \u2013 \u201dExport Server Package\u201d and save IIS backup.<\/p>\n<p>On the destination server choose \u201cImport Server Package\u201d and import IIS backup from the source server.<\/p>\n<p>It will overwrite all the settings and sites in IIS.<\/p>\n<p>Correct DB connection links in IIS site for your SQL server.<\/p>\n<p>Go to Application pools, choose application pool for the site and enter to Recycling menu \u2013 click OK and recycle the site.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>SQL 2012<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>Create the same user on the destination SQL server.<\/p>\n<p>Create backup for each of DB and restore it on the destination server.<\/p>\n<p>Check the permissions on the DBs (db_owner for your user).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>IIS You have to install Microsoft Web Deployment Installer 4.5 and the modules below for IIS migration. Then you can choose from the server menu (right side) \u2013 \u201dExport Server Package\u201d and save IIS backup. On the destination server choose \u201cImport Server Package\u201d and import IIS backup from the source server. It will overwrite all [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,12],"tags":[],"class_list":["post-547","post","type-post","status-publish","format-standard","hentry","category-novosti","category-windows"],"_links":{"self":[{"href":"https:\/\/dety.net.ua\/index.php?rest_route=\/wp\/v2\/posts\/547","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dety.net.ua\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dety.net.ua\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dety.net.ua\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dety.net.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=547"}],"version-history":[{"count":1,"href":"https:\/\/dety.net.ua\/index.php?rest_route=\/wp\/v2\/posts\/547\/revisions"}],"predecessor-version":[{"id":548,"href":"https:\/\/dety.net.ua\/index.php?rest_route=\/wp\/v2\/posts\/547\/revisions\/548"}],"wp:attachment":[{"href":"https:\/\/dety.net.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dety.net.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dety.net.ua\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}