Environment Details:
Source Details: H2 Server
IP Address: [Link]
Login Username: training8
Password: Maveric@2023
Destination Details: SQL Server
IP Address: [Link]
Username:.\t24user
Password: Temenos$2023
Prerequisite:
Before Starting the import, Follow the below steps in SQL server
Step 1: Creation of Empty Database (in Destination)
Right click on Database > New Database >
Give DATABASE name (MSSQLPOC)
Click on browse in Owner > select the below user > OK > OK
STEP 2: SQL Server Configuration Manager > SQL server Network Configuration > TCP/IP > once
disable it and enable it again. Also note the port number(1433)
SQL Server Service > stop and start the MSSQLPOC and SQL server Agent
Step 3: To load the functions in the destination server, Copy all the queries from Source
[Link] (D:\Temenos\Transact\ModelBank\TAFJ\dbscripts\ms-sql) to Destination server
[Link] (C:\SQL2022\queries)
Note: Create Queries folder in SQL2022 folder of destination server.
Execute all the queries in SQL manager by changing the Database name (MSSQLPOC) you have
created in each query.
NOTE: to execute the query, select all and click on EXECUTE
STEP 4: Check the connection in source and destination server.
In start, Search for Windows Power shell and give the below command
test-netconnection <IP_ADDRESS> -port <PORT_NUMBER>
Example :
For Destination: test-netconnection [Link] -port 1433
NOTE: Port number is available in [Link]
Step 5 : From command prompt, Execute the below queries in destination server
Start > cmd
sqlcmd -SW19DNNT24TDBPOC
GO
EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
GO
EXEC sp_configure 'clr strict security', 0;
RECONFIGURE;
GO
use MSSQLPOC
GO
sp_configure 'clr enable', 0
GO
RECONFIGURE WITH OVERRIDE
GO
CREATE ASSEMBLY TAFJSQLServer from 'C:\SQL2022\queries\[Link]' WITH
PERMISSION_SET = SAFE
GO
alter database MSSQLPOC set trustworthy on
GO
exec sp_changedbowner tafjuser
GO
To check if the functions are loaded properly, execute the below command:
SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE =
'FUNCTION' ORDER BY ROUTINE_NAME
GO
DBImport : Once the connection between source and destination is established and
functions are loaded properly in destination, we can start the DB import.
D:\Temenos\Transact\ModelBank\TAFJ\bin
Open Command prompt by giving cmd in bin path.
Type DBImport -GUI and click enter and follow the below steps as shown in the screenshots
Once the DB import is completed , the below screen will appear.
POST CHECK IN SOURCE: Execute the below Queries in source server once the DB import is
completed.
tUserMgnt --Reset -u t24user -p Temenos@1234
DBTools -u t24user -p Temenos@1234
(NOTE*: DBTools Login to check the tables)
DBTools>JQL >COUNT [Link]
COUNT OF TAFJ:DBTools>SQL> SELECT COUNT(*) FROM TAFJ_VOC
SQL>SELECT COUNT(*) FROM TAFJ_VIEWDEP
POST CHECK IN DESTINATION: Execute the below Queries in destination server once the DB
import is completed.
To check the TAFJ_VOC count:
USE MSSQLPOC
GO
SELECT COUNT(*) FROM TAFJ_VOC
GO
Execute the below queries for the post check on customer:
SELECT * FROM TAJ_VOC WHERE RECID = '%CUSTOMER%'
GO
SELECT * FROM FBNK_CUSTOMER
GO
SELECT COUNT(*) FROM FBNK_CUSTOMER
GO
Execute the below queries to check TAFJ_VIEWDEP:
SELECT * FROM TAFJ_VIEWDEP
GO
SELECT COUNT(*) FROM TAFJ_VIEWDEP
GO
DBSIZE CHECK :
DESITINATION: Execute the below queries
SELECT
DB_NAME(db.database_id) DatabaseName,
(CAST([Link] AS FLOAT)*8)/1024 RowSizeMB,
(CAST([Link] AS FLOAT)*8)/1024 LogSizeMB,
(CAST([Link] AS FLOAT)*8)/1024 StreamSizeMB,
(CAST([Link] AS FLOAT)*8)/1024 TextIndexSizeMB
FROM [Link] db
LEFT JOIN (SELECT database_id, SUM(size) RowSize FROM sys.master_files
WHERE type = 0 GROUP BY database_id, type) mfrows ON mfrows.database_id =
db.database_id
LEFT JOIN (SELECT database_id, SUM(size) LogSize FROM sys.master_files
WHERE type = 1 GROUP BY database_id, type) mflog ON mflog.database_id =
db.database_id
LEFT JOIN (SELECT database_id, SUM(size) StreamSize FROM sys.master_files
WHERE type = 2 GROUP BY database_id, type) mfstream ON mfstream.database_id =
db.database_id
LEFT JOIN (SELECT database_id, SUM(size) TextIndexSize FROM
sys.master_files WHERE type = 4 GROUP BY database_id, type) mftext ON
mftext.database_id = db.database_id
CONFIGURING TAFJ PROPERTIES in SOURCE:
Make the below changes as per the screenshots in TAFJ properties in source:
jdbc:sqlserver://<host_or_ip>:1433;databaseName=<db_name>;integratedSecurity=True
Change it according to the destination server details
[Link]=jdbc:sqlserver://
[Link]:1433;databaseName=MSSQLPOC;integratedSecurity=false
[Link]=[Link]
[Link]=tafjuser
[Link]=123)
Save and EXIT and login again into the dbtools
DBTools -u t24user -p Temenos@1234
NOTE:
Follow all the instructions given in this document for MSSQL and Oracle import as
well by changing the respective paths, IP address and port numbers from TAFJ
properties
Source details: MSSQL
Path : jdbc:h2:tcp://localhost:3458/DEV
username=t24
password=t24
Target details: Oracle
path:
jdbc:sqlserver://[Link]:1433;databaseName=ORACLEDBDEMO;integratedSec
urity=false
username= tafjuser
password=123
DB Name: ORACLEDBDEMO
PUTTY DETAILS: Oracle
IP: [Link]
Username: t24user
Password: Temenos@2023
properties file Path: /home/t24user/TAFJ/conf/[Link]