We call the Server the computer where the SQL Database is running. This can be one of the computers just running Windows (as in a Peer to Peer network), or it can be a dedicated Server.
The server should ideally have
•A reasonable processor (at least a Dual Core)
•A good amount of RAM Memory (at least 4GB)
•A network card at least as fast as the Router / Hub can handle (at least: 100mbs)
•A fast Hard Drive with enough space
•A late operating system (Windows 7, Windows 10 or Windows Server 2008 or later)
Ensure the computer is configured and ready to connect to the Network.
•Make a note of the exact Computer Name (Right click My Computer / Properties / Computer Name)
•Ensure it is in the same Workgroup as the other computers on the network (Right click My Computer / Properties / WorkGroup)
•The Network card is set to obtain the IP automatically, or if Manual, it is in the right range (Network / Local Area Connection / Properties / Internet Protocol 4 / Properties)
•Share a folder for Evopos file (normally: \bbscd or \EvoposShared) with everyone
•Share a folder for company files (Normally: \Docs) with everyone
There are two common methods of replacing the server:
•On-Line Replacement -Where the computer is already connected to the network
•Off-Line Replacement - Where the computer is not connected to the network
The main difference between the two is that on the Off-Line Replacement you can keep the same Computer Name (or Internal IP address) to avoid changing the connection details on all the other computers.
This method enable you to have the new server on the network at the same time as the old server
•Take a Backup on the old SQL Server to get the latest data and copy it to the new server
•Ensure the computer is connected to the network and has Evopos Installed
•Ensure the new servers name is entered as SQL Server. If starting for the first time it should show the connection screen. If Evopos is already running, select Settings and see if the Server name is set next to the Change Database button. If not select Change Database and enter on the Connection screen.
•If SQL Server has not been installed on that computer it will prompt to Run and Install SQL Server. It will then prompt to Create the database from a backup and you would select the latest backup.
•If the database is already running select Settings and select the Restore Database button and select the latest backup
•Ensure the SQL exceptions have been added to the Firewall (see Help / Installing)
•Go to each computer that connects to Evopos and change the connection details to the new server details
This method has the option to set the server name and other SQL connection details to the same as the old server so you do not have to change all the connection details on all the other workstations. The server can also prepared elsewhere and then swapped over in a few minutes when on site.
•Ensure the new server is disconnected from the Network (or has a different Computer Name). Setup with Evopos and create the SQL database (See Help / General / Install Evopos)
•Take a Backup on the old SQL Server to get the latest data and copy it a USB drive or a shared location
•Shut down all computer (or at least come out of Evopos)
•Remove the old Server (or rename the Computer name)
•Connect up the new server with the same name and Restore the latest Backup
•Restart the other computers