To migrate to Version 6 of ProCal you will need to install a free copy of SQL Server from Microsoft. Transmille recommends that SQL Server 2012 (Service Pack 2) and above are used.
SQL Server 2012 can be downloaded from Microsoft at the following link: https://www.microsoft.com/en-gb/download/details.aspx?id=29062
On the download page, ensure that the file ENU\x64\SQLEXPRWT_x64_ENU.exe is selected for download (File Size 669.9MB).
NOTE : If you are running a 32 Bit computer to host the SQL Server Installation, replace x64 with x86 in the above download names.
Run the installer and follow the steps below :
Run the downloaded .exe file, and select 'New SQL Server stand-alone installation or add features to an existing installation'
At the next screen, ensure that you tick the 'Include SQL Server Product Updates' to make sure that you have the latest version for a fresh install
The installer will download and extract any additional files that are required
When the installer proceeds to the next screen, ensure that 'Perform a new installation of SQL Server 2012' is selected
After reading the software licence terms for SQL SErver 2012 Express (Please note that this software is provided by Microsoft and not Transmille), tick the 'I accept the license terms' check box and click next
Ensure that Database Engine Services is ticked (the default selection) and click next
On the following screen, select 'Named Instance' and enter TRANSMILLE for the name of the instance and click Next. If SQL Server is already installed on your computer/server the existing instances will appear in a list below. If the TRANSMILLE instance already exists please contact your systems administrator as you may already have ProCal installed
Ensure that the SQL Server Database Engine and SQL SErver Browser services are set to Startup Type 'Automatic' and click next
Select the 'Mixed Mode (SQL Server authentication and Windows authentication)' options and enter a password. Transmille advise using the password 'transmilleProcal' however this should only be used on systems that are not accessible from the internet
NOTE - THIS PASSWORD IS REQUIRED TO CREATE TABLES, USERS ETC. PLEASE ENSURE THAT IT IS MEMORABLE
If desirable, tick the error reporting confirmation box on the next page, however, this can be left unchecked
Clicking Next starts the installation which can take up to 20 minutes. During this time the computer/server should not be restarted.
After completing the installation and restarting the computer, the Transmille ProCal server configuration utility can be downloaded and run. This configures the database with no information, ready to be populated by ProCal, ProCal-Track, and ProSales. For instructions on using the ProCal Server Configuration Utility please read the following article : Server Configuration Utility