~: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.
- Data Profiling Tool
- DB Analyzer consolidate report (Summary & details)
- Pre Migration Tool
- Data Profiling Tool
- DB Analyzer consolidate report (Summary & details)
- MDE DPT Report
- NSS87_seq_logic_tool
- Sign Shrink Tool
- Closer Remark Changer.exe
- Advance Query for Go Live.exe
- Special Character Removal Tool.exe
- Clear temp files and Recycle Bin
- Finally Click on "RUNALL.Bat" form DM_utility.
- On Successfully Migration, Run the CBS Key Po Report
(Step:-4)
Procedure for eMail & Content of eMail to DMCC:-
- Both *_dcy.csv and *_ency.csv files of Data profiling tool.
- Summary & details report files of DB Analyzer.
- Log file of Pre Migration tool.
- MDE DPT report file.
- Screen Shot of Filezilla Paths for DM tool File Path, SP tool file Path, DMCC file Path.
- Screen Shot of CBS Key PO.
- Summary and Live accounts reports of CBS Key PO.
- DMCC File of CBS Key PO.
- SP Tool & DM Tool Status Report Files.
- Post Master Certificates.