How to do a Migration Beat to Live,


Example Video on Migration 
https://web.microsoftstream.com/video/8f2f19dd-2351-4057-b50d-082c0bb8675a


1. Create a ticket request to do the DB migration from the Host Team.
Use the following link to create Tickets.

Already Created example
Anajet: https://sanacommerce.visualstudio.com/Sana%20Hosting/_workitems/edit/60840
Coulisse: https://sanacommerce.visualstudio.com/Sana%20Hosting/_workitems/edit/88912/

2.Copy Beta data to LiveUpgrade(newly created)
2.Copy Lived data to LiveUpgrade(newly created)
Tables,
2.1 WebsiteDomains Table
eg : Copy WebsiteDomains table details to AnaJetLive(Live) to AnaJetLiveUpgraded(newly-created DB). 

2.2 Setting Table
(need to remove connection settings otherwise it will give an error and will not load the project)
Remove Key=Connection from LiveUpgrade.



  
  1. Come to the server, takes full backup of Live DB
                        for safety, create a zip file of this backup.

  1. Change web.config file with New Database.

4.1 Do the decrypt the web.config file
      > cd C:\Windows\Microsoft.NET\Framework\v4.0.30319
      >aspnet_regiis -pdf "connectionStrings" "C:\Sana Commerce\Projects\BetaSanaStore\Frontend"

4.2 Before updating db name double-check, the site is working after decrypting the web.config.
4.3 Update web config with new DB Name.
4.4 Restart app pool

  1. Duplicate the Sana Admin page and go to user Manager >Edit Live Backoffice user (Keep it) 

    6.  After change the Database name, the Site's Backoffice Account also change,
         (because we created the new DB as a copy of the Beta database).

          6.1  so go to the back-office and log with Beta Backoffice credentials.

   7. Change password back to Live Backoffice credentials.
        7.1 go Admin section > User management > change to Live credentials .
        7.2 Check the Permission are same as before with user manager  page duplicated earlier.
  
   8.  Then Log out and login with Live credentials.

   9. fill ERP details from starter site  >ERP web  service.
       9.1 Test the connection.

  10. Then need to run tasks



for live set task server to true
<add key="TaskServer" value="true" />
       
10.1 if web service not set I by Database:- 'Servers' table, set Live and Liveupdate look same.
Refresh both caches (ERP, site)

        run General , Customer ,Product



  1. Install Addons.

Go to Live db > Settings table > check any Extensions installed , Delete  them.
Eg: Extension_AuthorizeNet, Extension_FedEx.

  1. Copy the Addon settings from Beta to PreLive eg : Authorize.net ,FedEX.
  2. Check Payment Methods show properly if have.
  3. Check Shipping Method ""

  1. Go to Website view  and check missing images ,
Product images no need to copy, but if some images are used in same pages , then add

  1. If all looks fine Change DB names, to change  as shared sana Admin on DB
  2. eg : AnajetLive--> AnajetLive_old
  3. Eg : AnajetUpgrade --> AnajetLive


Then do Smoke Test.