Changing Backend Database from MySQL to SQL Server 2005
Need some urgent help with migrating the MySQL database to a SQL Server 2005 environment. Below are the steps that I have followed so far.
- Created an ODBC connection to the MYSQL database
- Used SQL Servers DTS tool to migrate the database from MySQL to SQL Server 2005
- Upgraded the Service Desk service packs to bring the application up to the most current version 7018.
- executed the changedbserver.bat file in the following directory C:\AdventNet\ME\ServiceDesk\bin to point the service desk application to the new SQL Server backend.
When I performed the changeDBServer task however the application wants to create a new backend instance so I detached the service desk backup that I migrated from MySQL, executed the 'changeDBServer.bat' file and let the application create a new database instance. I then detached the instance that the application created and restored it with the original instance that I migrated from MySQL and can no longer start the service desk service or launch the client application.
Please help!!!!
- Created an ODBC connection to the MYSQL database
- Used SQL Servers DTS tool to migrate the database from MySQL to SQL Server 2005
- Upgraded the Service Desk service packs to bring the application up to the most current version 7018.
- executed the changedbserver.bat file in the following directory C:\AdventNet\ME\ServiceDesk\bin to point the service desk application to the new SQL Server backend.
When I performed the changeDBServer task however the application wants to create a new backend instance so I detached the service desk backup that I migrated from MySQL, executed the 'changeDBServer.bat' file and let the application create a new database instance. I then detached the instance that the application created and restored it with the original instance that I migrated from MySQL and can no longer start the service desk service or launch the client application.
Please help!!!!