Migrating from MySQL to SQL 2012 -- SUCCESSFUL
I was attempting to migrate from the bundled MySQL instance with DesktopCentral Build #80035 to Microsoft SQL 2012 running on another server, but was running into errors on the restore.
I looked at the following discussions, which provided some value:
- https://forums.manageengine.com/topic/migrating-from-mysql-to-sql-2005
- https://forums.manageengine.com/topic/migrating-from-mysql-to-sql
- https://forums.manageengine.com/topic/mysql-to-mssql-on-desktop-central
(this one could have been more helpful)
Here was the error that I was receiving upon attempting a restore:
Unable to restore database : Cannot find the object "trace_xe_event_map" because it does not exist or you do not have permissions.
I followed the instructions in the following link, since the error was very similar as mine, even though it was for the ServiceDesk product:
This led to a new error message (just like everyone else in that thread).
Unable to restore database : Cannot alter 'trace_xe_event_map' because it is not a table.
I then searched Google for the following error message:
Cannot alter 'trace_xe_event_map' because it is not a table.
This led me to the following link, and what appears to be success:
I dropped the synonyms I created, and then executed the following T-SQL commands:
USE [master]GODENY ALL ON [sys].[trace_xe_action_map] TO [desktopcentraluser]GODENY ALL ON [sys].[trace_xe_event_map] TO [desktopcentraluser]GO
Now, my Mysql_Mssql_Restore.BAT is working properly and has completed the restore!