MYSQL to MSSQL Migration Failure
I've attempted to migrate from MYSQL to MSSQL but i've hit a bit of a road block i'm hoping you can assist with.
I've followed the instructions as outlined in the servicedesk forums: http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=
I've successfully backed up the database without error, converted to MSSQL, start/stop SD+ and now i'm running the restore of data, at which point i get stuck at the following...
"Unable to restore database : Invalid object name 'accolumnconfiguration'."
The accolumnconfiguration table was added to the database on the sql server during the migration and it doesnt appear to have any errors.
Is anyone able to assist? I'd like to get the database migrated to MSSQL asap as MYSQL is running very slow.
Also it might be worth noting that when i run the backup, it takes approximately 13 hours to complete. Our DB is just under 4GB and i'm not sure if this is a normal time frame for this to take...
Cheers,
Phill
I've followed the instructions as outlined in the servicedesk forums: http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=
I've successfully backed up the database without error, converted to MSSQL, start/stop SD+ and now i'm running the restore of data, at which point i get stuck at the following...
"Unable to restore database : Invalid object name 'accolumnconfiguration'."
The accolumnconfiguration table was added to the database on the sql server during the migration and it doesnt appear to have any errors.
Is anyone able to assist? I'd like to get the database migrated to MSSQL asap as MYSQL is running very slow.
Also it might be worth noting that when i run the backup, it takes approximately 13 hours to complete. Our DB is just under 4GB and i'm not sure if this is a normal time frame for this to take...
Cheers,
Phill