major upgrade, new server hw & sw and new installation type

Question asked by Poin Dexter - 11/10/2016 at 11:15 AM

Answered

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

Employee Replied

11/10/2016 at 12:14 PM

Employee Post Marked As Answer

Greetings,

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.

Poin Dexter Replied

11/10/2016 at 2:28 PM

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):

[Management.Settings.frmDatabaseWizard_ErrorExecuting]

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

Back to Community Threads

Please leave this box unchecked

Reply to Thread

Enter the verification text