How to Migrate from SIMS Flat File to SIMS SQL (using SIMS II Migrator)
Migrating SIMS II Flat File to SQL
Connect to the SQL server, (remember if you connected with Windows authentication or User Name and Password because you will need that for migrator configuration) and be sure SQL Management Studio is insta...
SIMS II Migrator Installation and Setup
Pre-Requisites:
All Windows Updates installed on computer
Microsoft .net 4.7 or higher installed
Automatic Windows updates disabled
Installation instructions:
**Computer needs to be logged in as an Administrator**
...
SIMS SQL Query - Must run in Master before doing Migrate in SQL 2016 or higher
EXEC sp_configure 'show advanced options', 1
RECONFIGURE;
EXEC sp_configure 'clr strict security', 0;
RECONFIGURE;