SP ALL IN ONE TOOL BY INFOSYS FOR CBS MIGRATION

Sanchay Post All In One Tool By Infosys

Download

Download

SP Tool Is Used For The Following Purposes: -

1. Generating the Data Profiler report.

2. Creating tables in MSSQL Server for calculating interest.

3. Interest calculation.

4. Extracting the POST tables into flat files. Zip them and Ftp

5. Extracting the SIGN images into flat files. Zip them and Ftp

Instructions To Install

1. Create a folder called SPPackage.

2. Download the SPTool_v.zip file from the site given by DoP and Save the .zip file to the SPPackage folder.

Note: Always download the latest version or specified version from above site.

3. Extract the zip file and put the contents of the zip file in the folder SPPackage created in step 1 

How To Execute SPTool

Preconditions: -

Before executing SPTool the following needs to be done.

• Open the SQL Management Studio/ SQL Enterprise Manager.
• Check for DCL user in the SQL server.
• Open the sptool.reg present inside the SPPackage folder using Notepad.exe.

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\sptool]
"Driver"="C:\\Windows\\system32\\sqlsrv32.dll" "Server"="(local)" Change (local) Sql server name
"Database"="POST"
"LastUser"="sa"

• Open the userBmpCon.reg present inside the SPPackage folder using Notepad.exe.

Windows Registry Editor Version 5.00
Confidential and Proprietary to India Post and Infosys Limited 8
[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\bmpCon]
"Driver"="C:\\Windows\\system32\\sqlsrv32.dll" "Server"="(local)" Change (local) Sql server name
"Database"="SIGN"
"LastUser"="sa"

• Open the SQL Management Studio/ SQL Enterprise Manager, right click on the server name.
• Fetch the value of the Name key (Highlighted one) and replace for (local) (shown above).

Fore More Details Refer the manual inside the SP All in one Tool.

Source : http://potools.blogspot.in