1. Sanchay Post for SOSB is in operation at HO
If Sanchay Post software for SOSB is in operation at HO, then the following steps are to be performed at SO.
• The network operating system has to be installed.
• SQL server has to be installed.
• Sanchay Post Software has to be installed.
• Make a folder called ‘POST’ in the drive where SB databases are intended to be created. Ensure availability of enough space in the selected drive.
• Using ‘Database Operations Create DB’ option of Sanchay Post, database has to be created.
• Take a backup of the SO database (available at HO)
• Backup of respective SO database is to be restored at the SO with the same database name using SQL Server Enterprise Manager. The steps involved are listed below:
Select ‘POST’ database. Select Tools Data Transformation Services Import Data from the menu. This will launch the DTS Export / Import Wizard.
Select the SO database as the source database in ‘Choose a Data Source’ screen.
‘POST’ database will be automatically selected as the ‘Destination’.
Select the option ‘Copy objects and data between SQL Server databases’ in ‘Specify table copy or query’ screen.
Select the tables to be imported. (Assumed that no data is available at SO for the tables you are selecting).
A message will be received on successful data transfer.
• After this transfer, data fed at HO in respect of the SO, up-to the day begin date of SOSB module at the time of backup will be available in the SO. Subsequently, Daily LOTs are to be fed in Sanchay Post till the current date to make the operations at SO on-line.
o List of tables to be transferred for each scheme is given below:
Scheme Table name
MIS mindxreg
mledger
PPF ppf_indexreg
ppf_ledger
ppf_loandet
ppf_extended_period
TD td_withdraw
td_indexreg
td_ledger
SCS scs_index
scs_ledger
scs_withdraw
scs_docs
RD accountopen_through_agent
rdindex
rdjrnl
rddflt
rdmisc
rdbulk_index
rdbulk_ledger
institution_details
SB indexreg
ledger
nomineeinfo
introducer
interestposting
ibb
NSS nss_indexreg
nss_ledger