Cannot migrate SD+ from MySQL to MSSQL
I'm using servicedesk plus build 6013 with mysql-db
I tried to migrate the db to MSSQL. These are the steps:
7. stop server
8. backup db
9. changedbserver to MSSQL with sa account
Test OK, sucessfully created - but only !!! sys..tables are created !!!
10. start / stop server
11. restore db
12. reboot windows 2003 server
sd+ stop starting while loading "ServerContainer"
I also tried to change to MSSQL-DB with a fresh installation of sd+ with MSSQL-Support. Therefore I installed sd6+ (build 6000) on a testsystem.
Only the following systables are created:
sysusers dbo System 06.08.2000 01:29:12
systypes dbo System 06.08.2000 01:29:12
sysreferences dbo System 06.08.2000 01:29:12
sysprotects dbo System 06.08.2000 01:29:12
sysproperties dbo System 06.08.2000 01:29:12
syspermissions dbo System 06.08.2000 01:29:12
sysobjects dbo System 06.08.2000 01:29:12
sysmembers dbo System 06.08.2000 01:29:12
sysindexkeys dbo System 06.08.2000 01:29:12
sysindexes dbo System 06.08.2000 01:29:12
sysfulltextnotify dbo System 06.08.2000 01:29:12
sysfulltextcatalogs dbo System 06.08.2000 01:29:12
sysforeignkeys dbo System 06.08.2000 01:29:12
sysfiles1 dbo System 06.08.2000 01:29:12
sysfiles dbo System 06.08.2000 01:29:12
sysfilegroups dbo System 06.08.2000 01:29:12
sysdepends dbo System 06.08.2000 01:29:12
after restoring the db of the productive system the sd+ stopped starting while loading "ServerContainer"
for more information see the atteched logfiles
New to ADSelfService Plus?