Migrate mysql to mssql

Hi,

Trying to migrate from mysql to mssql, I've created a empty db and it fires up ok. when i do the restore data however i get the error below

SEVERE: haltjvm.on.dbcrash is set to [false]
Oct 06, 2018 10:41:44 PM com.adventnet.db.adapter.Jdbc20DBAdapter getShutDownStr
ings
INFO: shutDownStrings :: []
Oct 06, 2018 10:41:44 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTe
mplates
INFO: Loading the function patterns from the file :: [null\conf\Persistence\mssq
l_functionpatterns.txt]
Oct 06, 2018 10:41:44 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTe
mplates
SEVERE: Exception occurred while parsing the file :: [null\conf\Persistence\mssq
l_functionpatterns.txt]
java.io.FileNotFoundException: null\conf\Persistence\mssql_functionpatterns.txt
(The system cannot find the path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.adventnet.db.adapter.Jdbc20DBAdapter.loadFunctionTemplates(Jdbc20
DBAdapter.java:2062)
at com.adventnet.db.adapter.Jdbc20DBAdapter.initialize(Jdbc20DBAdapter.j
ava:213)
at com.adventnet.db.adapter.mssql.MssqlDBAdapter.initialize(MssqlDBAdapt
er.java:92)
at com.adventnet.persistence.PersistenceInitializer.initializeRelational
API(PersistenceInitializer.java:447)
at com.adventnet.persistence.PersistenceInitializer.initializeDB(Persist
enceInitializer.java:466)
at com.adventnet.persistence.PersistenceInitializer.initializeDBAndDBPro
ps(PersistenceInitializer.java:339)
at com.adventnet.persistence.service.DatabaseFactory.startDB(DatabaseFac
tory.java:617)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:292)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:116)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:188)
at java.lang.Thread.run(Unknown Source)
Oct 06, 2018 10:41:44 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
SEVERE: Error while trying to instantiate SQLGenerator :: {0}
java.io.FileNotFoundException: null\conf\Persistence\mssql_functionpatterns.txt
(The system cannot find the path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.adventnet.db.adapter.Jdbc20DBAdapter.loadFunctionTemplates(Jdbc20
DBAdapter.java:2062)
at com.adventnet.db.adapter.Jdbc20DBAdapter.initialize(Jdbc20DBAdapter.j
ava:213)
at com.adventnet.db.adapter.mssql.MssqlDBAdapter.initialize(MssqlDBAdapt
er.java:92)
at com.adventnet.persistence.PersistenceInitializer.initializeRelational
API(PersistenceInitializer.java:447)
at com.adventnet.persistence.PersistenceInitializer.initializeDB(Persist
enceInitializer.java:466)
at com.adventnet.persistence.PersistenceInitializer.initializeDBAndDBPro
ps(PersistenceInitializer.java:339)
at com.adventnet.persistence.service.DatabaseFactory.startDB(DatabaseFac
tory.java:617)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:292)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:116)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:188)
at java.lang.Thread.run(Unknown Source)

Oct 06, 2018 10:41:44 PM com.zoho.framework.utils.crypto.EnDecryptImpl decrypt
SEVERE: Encryption failed
Oct 06, 2018 10:41:44 PM com.adventnet.persistence.PersistenceInitializer initia
lizeRelationalAPI
INFO: DataSourcePlugIn is initialized successfully
Oct 06, 2018 10:41:44 PM com.adventnet.persistence.PersistenceInitializer create
DestinationDataBase
INFO: create.db is :: null
Oct 06, 2018 10:41:44 PM com.adventnet.persistence.PersistenceInitializer getTem
platesReplacedUrl
INFO: Template replaced url :: jdbc:jtds:sqlserver://HQOSVSQL003:1433;DatabaseNa
me=servicedesk_new;Tds=8.0;PrepareSql=3;XaEmulation=false;
Oct 06, 2018 10:41:44 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggle
Collation
INFO: Incoming collation string is Latin1_General_CI_AS
Oct 06, 2018 10:41:44 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggle
Collation
INFO: Collation String constructed is Latin1_General_CS_A%
Oct 06, 2018 10:41:44 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggle
Collation
INFO: The Toggle collation string is Latin1_General_CS_AI
Oct 06, 2018 10:41:44 PM com.adventnet.db.adapter.AbstractRestoreHandler doResto
reSanityTesting
INFO: Restore process fully completed.
Oct 06, 2018 10:41:44 PM com.adventnet.db.adapter.Jdbc20DBAdapter getDBProps
INFO: splitConnectionURL :: {DatabaseName=servicedesk_new, PrepareSql=3, Port=14
33, url_props_delimiter=;, urlWithoutProps=jdbc:jtds:sqlserver://HQOSVSQL003:143
3, jdbcurl_props_separator=;, Tds=8.0, properties={Tds=8.0, XaEmulation=false, S
erver=HQOSVSQL003, PrepareSql=3, DatabaseName=servicedesk_new, DBName=HQOSVSQL00
3:1433, Port=1433}, DBName=HQOSVSQL003:1433, XaEmulation=false, Server=HQOSVSQL0
03, urlProps={Tds=8.0, XaEmulation=false, PrepareSql=3, DatabaseName=servicedesk
_new}}
Oct 06, 2018 10:41:44 PM com.adventnet.persistence.PersistenceInitializer getTem
platesReplacedUrl
INFO: Template replaced url :: jdbc:jtds:sqlserver://HQOSVSQL003:1433;DatabaseNa
me=servicedesk_new;Tds=8.0;PrepareSql=3;XaEmulation=false;
Active DB Server = mssql
Database connectionProp : null
Oct 06, 2018 10:41:49 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTe
mplates
INFO: Loading the function patterns from the file :: [null\conf\Persistence\mssq
l_functionpatterns.txt]
Oct 06, 2018 10:41:49 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTe
mplates
SEVERE: Exception occurred while parsing the file :: [null\conf\Persistence\mssq
l_functionpatterns.txt]
java.io.FileNotFoundException: null\conf\Persistence\mssql_functionpatterns.txt
(The system cannot find the path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.adventnet.db.adapter.Jdbc20DBAdapter.loadFunctionTemplates(Jdbc20
DBAdapter.java:2062)
at com.adventnet.db.adapter.Jdbc20DBAdapter.initialize(Jdbc20DBAdapter.j
ava:213)
at com.adventnet.db.adapter.mssql.MssqlDBAdapter.initialize(MssqlDBAdapt
er.java:92)
at com.adventnet.servicedesk.tools.ConnectionUtil.getDBAdapter(Connectio
nUtil.java:195)
at com.adventnet.servicedesk.tools.ConnectionUtil.getConnection(Connecti
onUtil.java:60)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:294)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:116)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:188)
at java.lang.Thread.run(Unknown Source)
Oct 06, 2018 10:41:49 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
SEVERE: Error while trying to instantiate SQLGenerator :: {0}
java.io.FileNotFoundException: null\conf\Persistence\mssql_functionpatterns.txt
(The system cannot find the path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.adventnet.db.adapter.Jdbc20DBAdapter.loadFunctionTemplates(Jdbc20
DBAdapter.java:2062)
at com.adventnet.db.adapter.Jdbc20DBAdapter.initialize(Jdbc20DBAdapter.j
ava:213)
at com.adventnet.db.adapter.mssql.MssqlDBAdapter.initialize(MssqlDBAdapt
er.java:92)
at com.adventnet.servicedesk.tools.ConnectionUtil.getDBAdapter(Connectio
nUtil.java:195)
at com.adventnet.servicedesk.tools.ConnectionUtil.getConnection(Connecti
onUtil.java:60)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:294)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:116)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:188)
at java.lang.Thread.run(Unknown Source)

Oct 06, 2018 10:41:49 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
SEVERE: Exception occured while initializing datasource.
Oct 06, 2018 10:41:49 PM com.zoho.framework.utils.crypto.EnDecryptImpl decrypt
SEVERE: Encryption failed
Database started