Migrate MySQL to MSSQL
I'm using SD+ 7 with mySQL right now. For some reason, we have purchase the MSSQL and try to migrate the system to run under it.
After that, I use "changedbserver.bat" to do the migration. In this process, I've check that all settings and tested by click the "Test" button.
When I start the service, it seems hang and it keep loading in the process "Application Layout xxx". Then I've try to rollback to mySQL and it can work sucessfully.
For this case, I've try to delete the database for servicedesk which stored in the MSSQL... and let it create a new one, but it's still hang.
For your reference, I've not restore the DB to MSSQL, so it must be a clear database.
Also, after the above process I did, the system is very slow when startup... usually the system have to shopw "Application Layout xxx" with "..." for a long time.
After that, I use "changedbserver.bat" to do the migration. In this process, I've check that all settings and tested by click the "Test" button.
When I start the service, it seems hang and it keep loading in the process "Application Layout xxx". Then I've try to rollback to mySQL and it can work sucessfully.
For this case, I've try to delete the database for servicedesk which stored in the MSSQL... and let it create a new one, but it's still hang.
For your reference, I've not restore the DB to MSSQL, so it must be a clear database.
Also, after the above process I did, the system is very slow when startup... usually the system have to shopw "Application Layout xxx" with "..." for a long time.