TopSpeed to SQL

This document covers the upgrading of the latest Eco Time TopSpeed version to the latest Eco Time SQL version.  Always upgrade your TopSpeed version first before upgrading it to SQL.
The SQL version of Eco Time uses Microsoft SQL Server (2000 and later) as the database server.  Please check that your server meets the[ hardware and software requirements for SQL Server|http://msdn.microsoft.com/en-us/library/ms143506.aspx#SEx64].
It is assumed that a version of Microsoft SQL Server is already installed and ready for use.
 
CONTENT

1. Create a SQL database
2. Configure the SQL Login(s)
3. TopSpeed Preparation
4. Uninstall the TopSpeed version
5. Install Eco Time SQL
6. Configure the SQL connect details
7. Notes

Before you install Eco Time you need to create a database on your SQL server.
Example:

1. Using Microsoft SQL Server Management Studio, create a new database called EcoTime.

1. Set the collation of the database to Latin1_General_CI_AS.

Eco Time SQL can connect to the database using SQL or Windows authentication.  Please check that your login(s) meet the server and database roles below.
Example:

1. Create a new login Eco Time which uses*SQL Server autentication*.

1. Select the following Server roles:bulkadmin,dbcreator,public*and*securityadmin.

1. Map the user to the EcoTime database and set the Database role membership to db_owner.

Before you start you need to make sure that your TopSpeed database is in a good condition.

1. Make a backup of your Eco Time data in an easy to find folder using the Eco Time Backup Module.
2. Close and keep closed the Eco Time Server Module and any other open Eco Time modules on your computer and on the network.
3. Open the Eco Time Configuration module, click on the File drop down menu and select File Manager.
4. Click on Tag All and click on the Freshen button. This may take some time to complete as all your data records are written to new database files.
5. When you see error messages, click on Retry.
6. When the Freshen is done, click on Verify Guids.
7. Click on Ok on any error messages.
8. When the process is complete close the File Manager and the Configuration module.
9. Go to the Eco Time Data directory and delete the Message.tps and Dates.tps file.

To prevent any problems with employees working in the wrong version or clockings collected to the wrong database, please uninstall the Eco Time using the option in Windows Control Panel to remove software packages.

Download the Eco Time SQL version and save it somewhere on your computer. The file name will be Eco Time_Setup_mssql_.exe for the Microsoft SQL Server version.  When the download is complete, open and run the file. 

1. An install wizard will open to guide you through the installation.
2. Install the application to the same path where the Eco Time TopSpeed version was located.
3. The data path must be the path where your Eco Time TopSpeed data is located.
4. When the installation is complete you will see a window in which you have to enter the SQL connection details. Click on Cancel.
5. The Connecting window will close. Click on Finish in the window below to complete the installation.

1. Make sure all the Eco Time application users have full read and write permissions to the Eco Time folders.
2. To help prevent data corruption, please do the following after installation:
   1. Exclude the Eco Time application and data files from real-time scanning by your anti-virus software.
   2. Exclude the Eco Time data folder from any automatic backups or make sure quiet time is set in Eco Time after the data has been upgraded.

1. Open the Configuration module using the shortcut in your Windows Start menu.  You will see the following window: Enter the SQL login and password next to UserName and Password. If you are using Windows authentication leave these fields empty. RememberPassword will save the password and Auto Login will connect automatically the next time you open Eco Time.  Do not select Auto Login until you have successfully connected to Eco Time. Click on Next to enter the Server details.
2. Enter the Server IP address and the SQL Instance name if one exists e.g. SQLServer\SQL2008. Enter the database name you created in Step 1. Click on Connect.
3. Eco Time will now start to create and populate the tables in the database: This process may take a long time to complete. Once this process is complete the Configuration module will open.
4. Close the Jumpstart window and click on the File drop-down menu.  Select File Manager, Tag All and click on Info to create the remaining tables.  Close the File Manager screen when you are done.  Close Eco Time.
5. Use Windows Explorer to go to C:\ProgramData\CSTime and edit the cstime.ini with Notepad.  Add the following code below the last line: Server Defrag = 0 Save the file and close it.

• Most of the data will be imported into the SQL database, but this does not mean that you can delete the files in the Eco Time data directory.  The following files and folders must be kept and if possible also backed up:  checks.tps, dssw5.tps, secwin.ini, system.tps, upg.tps, the Data and Temp folders.
• If the upgrade process shows no progress after a reasonable time you can end the upgrade process. Drop the table in SQL it was busy upgrading last and repeat point 4 under the Configure the SQL connect details. 
• To force an upgrade check on all the SQL backend files: Stop the server module.  Tick Force FM3 Full Data Structure Comparison (/GoInDeep) the Debug Options tab of the connection window. Then open the Eco Time Configuration Module, File, File Manager, Tag All, Info to touch all the files. Remember to untick this option afterwards.