Hello hn
Our DB will run on 2005 or later but we recommend grabbing 2017 and 2019 as they have some useful functionality for our other services like iW8 or Backup.
We typically do the server transfers at $120 per hour. Normally, we finish the transfer in one to two hours. iW8 and Backup customers are free if done during our open hours. After hours support for iW8 and Backup will be billed at the same rate. You can do the transfer yourself if you’d like to. Below are steps to transfer the server:
Locate database files and copy the following two files - WeighingSystem.mdf & WeighingSystem_Log.ldf
Install SQL, allow TCP/IP on static port and named pipe connections. Attach DB.
Install software on new PC, choose Advanced Installation, select your DB.
Copy the following directories over:
i. Recipts (resides in the executable’s directory),
ii. Media files (path in Settings -> Parameters -> General)
iii. Scales (if using scale on new PC, resides in the executable’s directory)
iv. Cameras (if using, resides in the executable’s directory)
v. Moisture Reader (if using, resides in the executable’s directory)
vi. Invoices (if using, resides in the executable’s directory)
vii. Law Export Path (if using, path in Settings -> Parameters -> Exporting
Update connection strings for ALL PCs to new server on login screen.
i. Click Options, press insert key on drop down menu that appears to get access to SQL connection settings.
Update ALL PCs Media Path and Law Export Path if applicable.
If you have devices to use on new server, we can install drivers needed to get them to work with new PCs.
See step ‘E’ and ‘F’ above to point the client PCs to the new server