major upgrade, new server hw & sw and new installation type
Question asked by Poin Dexter - 11/10/2016 at 11:15 AM
I'm looking to migrate AND upgrade from a manually installed ST 7.5.x (with IIS, c:\inetpub\smartertrack) on Windows Server 2003 64 bit to a automated installer installed ST 12.x on Windows Server 2016 Essentials. Please advise.

2 Replies

Reply to Thread
Von-Austin See Replied
Employee Post Marked As Answer
There are no known issues with running SmarterTrack on Windows Server 2016.
I would suggest performing the migration first, and then upgrading to the latest release.
Instructions to perform the migration can be found in our knowledge base here: https://portal.smartertools.com/kb/a2581/move-smartertrack-to-a-different-server.aspx
Once the migration has been completed, you'll want to follow the instructions in our KB article here: https://portal.smartertools.com/kb/a2620/upgrade-smartertrack.aspx
I hope this help.
Von See
Technical Support Supervisor
SmarterTools Inc.
(877) 357-6278
Poin Dexter Replied
After restoring the old "App_Data" folder and importing the old mysql database, the migration/upgrade wizards starts but stops with the following error message (and yes, the  database engine for all the tables is InnoDB):

Can't DROP 'FK_st_TimeLogs_st_TimeLogCategories'; check that column/key exists

Problem: Can't DROP 'FK_st_TimeLogs_st_TimeLogCategories'; check that column/key exists

Reply to Thread