NOTE: If you are running MISys versions between 6.4.6.4 and 6.4.6.6 do NOT proceed with the steps below. Instead, please contact MISys Technical Support (support@misysinc.com) for different instructions around upgrading your SQL version.
The steps below will walk you through updating your version of MS-SQL to your own free version of SQL Express. Please NOTE: The link below is for the free SQL Express 2014 however, if you desire a newer version of SQL Server you can find links to the other free SQL Express versions by searching Microsoft’s site.
Download and configure your own SQL Express Instance:
The free MS-SQL Express 2014 can be downloaded (from Microsoft’s site) using the following link:
https://www.microsoft.com/en-us/download/details.aspx?id=42299
NOTE: Be sure to select and download the appropriate version for your server’s operating system. A package that includes the free SQL Management Console is also available for download here should you so desire.
When configuring a new SQL Server Instance for MISys Manufacturing:
Once the SQL Instance is configured, you can follow these steps to migrate your MISys database(s) to the new SQL Instance.
Migrating your MISys database(s) to your new MS-SQL Server Instance:
At that point you will want to log into your live database through the MISys Client. Review the data to make sure it all looks good and verify the Master Transaction Log (under Reports | History) for the most current date you would have posted transactions to ensure you restored the correct Backup file. Once all looks good, have the Users log back in normally and review the data to ensure everything looks current. No changes need to be made from the workstations.
After you’ve processed for a number of days and are confident there are no problems, it is okay to remove the old SQL Instance through the Add/Remove Programs function of Windows.
Please don’t hesitate to reach out to us for assistance or questions with any of this.
« Go back