Mock Migration Procedure and Common DPT - DBA Solution

~:Preparatory Checklist for Mock Migration:~

Note:- The Mock migration or Actual Migration can never be done from original Server. We have to make a Backup Server. The details procedure are as under...

(Step :- 1)
  • A System with Minimum Windows 7, 4 GB RAM. 
  • Install JAVA (JRE 7 update 21)
  • Install Oracle.
  • SQL Server 2005 or 2008.
  • Restore the BPLOG, BPRO, POST, PROJECT, SIGN, SOSB and NREGAEMO database.
  • Update it for "DCL" permission from DB Analyzer >>DB Utility >> Update to SQL 2000 or SQL 2005/2008.
  • Run the Arrow.exe and Update NREGA user.exe
~:Tools required to install for Migration:~
  • Latest MDE (Install and update it)
  • Install DB Analyzer Package.
  • Download the latest DB Analyzer and update it.
  • Latest Data Profiling Tool.(Copy to C:\Data Profiling Tool)
  • Pre Migration tool.
  • Install the Sign Shrink Software.
  • NSS87_seq_logic_tool.exe
  • Dm_Utility (Latest available at SDC)
  • CBS Key Po tool
  • Filezilla Software
  • Closer remarks Queries.
  • Advance query for Go Live.exe (Tool for comparison data between MDE and POST)
  • Special Character Removal Tool.exe. 
(Step :-2)
  • Clear all the DPT and DBA Plus Discrepancies 
  • Delete the all temp file (Go to >>Run>> %temp%)
  • Delete all items from Recycle Bin.
  • Remove the system from indiapost.gov.in Domain network if already.
(Step :-3)

Run the following application and tools in given sequence for Migration.
  1. Data Profiling Tool
  2. DB Analyzer consolidate report (Summary & details)
  3. Pre Migration Tool
  4. Data Profiling Tool
  5. DB Analyzer consolidate report (Summary & details)
  6. MDE DPT Report
  7. NSS87_seq_logic_tool
  8. Sign Shrink Tool
  9. Closer Remark Changer.exe
  10. Advance Query for Go Live.exe
  11. Special Character Removal Tool.exe 
  12. Clear temp files and Recycle Bin
  13. Finally Click on "RUNALL.Bat" form DM_utility.
  14. On Successfully Migration, Run the CBS Key Po Report
(Step:-4)

Procedure for eMail & Content of eMail to DMCC:-
  1. Both *_dcy.csv and *_ency.csv files of Data profiling tool.
  2. Summary & details report files of DB Analyzer.
  3. Log file of Pre Migration tool.
  4. MDE DPT report file.
  5. Screen Shot of Filezilla Paths for DM tool File Path, SP tool file Path, DMCC file Path.
  6. Screen Shot of CBS Key PO.
  7. Summary and Live accounts reports of CBS Key PO.
  8. DMCC File of CBS Key PO. 
  9. SP Tool & DM Tool Status Report Files.
  10. Post Master Certificates.