Installation Instructions for Tennis PRO! 97 with SQL Server/MSDE and Master Script:
Note: Links to all third party (ie non-SSW) service packs and patches featured on this page can be found at http://www.ssw.com.au/SSW/database/LinksSoftwareUpdates.asp
1. Install Microsoft SQL Server 7.0 or the Microsoft Data Engine (MSDE). Approximate installation time: 3 minutes for MSDE, 18 minutes for SQL Server.
NOTE: MSDE is free and can be installed from any Access 2000 CD-ROM by running Setupsql.exe located in the \Sql\x86\Setup folder. Once you install MSDE on your computer, on Microsoft Windows 95 or later, you may need to start the SQL Server Service Manager (double-click the MSSQLServer icon on the task bar and click Start/Continue). MSDE starts automatically on Windows NT 4.0 or later; you might want to automatically start MSDE on Windows 95 or later by selecting the Auto-Start service when OS starts check box on the SQL Server Service Manager window.
2. Install Microsoft SQL Server 7.0 Service Pack 2 (SP2). This is a cumulative release, so you do not have to install Service Pack 1 as well. This works for both MSDE, and SQL Server. Approximate installation time: 8 minutes.
1. Install Microsoft Office 97, Service Pack 1and then Service Pack
2. These are incremental releases, so you will need to install both of them
in the right order.
Approximate installation time: 25 minutes
2. Download and Install MDAC 2.5 (Microsoft Data Access Components
version 2.5). The latest version can be downloaded from http://www.microsoft.com/data/download.htm
Approximate installation time: 6 minutes
3. Install the SSW Script Wizard. You can get it from www.ssw.com.au/SQLScriptWizard.
Approximate installation time: 5 minutes
4, Point the SSW Script Wizard to the master TennisPRO Database script. This master script can be found in www.ssw.com.au/TennisPRO/Download/SSWTennisPRODataScriptMaster652.sql
5. Run the Script with the 'SSW Script Wizard' to create the database
structure on your Server. This database is usually named "SSWTennisPROData"
& [Your Club Name or Initials]. E.g. "SSWTennisPRODataMyClub" or "SSWTennisPRODataMC".
The empty SQL/MSDE database the script creates is equivalent to Version 652
of the Tennis PRO! Access backend database.
Approximate installation time: 4 minutes
6. Install 'SSW Data PRO! SQL'. This can be found at www.ssw.com.au/DataPRO
Approximate installation time: 4 minutes
7. Once the database has been created on your SQL Server, and SSW Data
PRO! has been installed, install SSW Tennis PRO! 97. This can be found at www.ssw.com.au/TennisPRO/Download/TennisPRO97.exe
Approximate installation time: 5 minutes
8. Run Tennis PRO! 97. Use the attachment manager to attach the Front-End
(SSW Tennis PRO 97) to the SQL Server or MSDE Backend. For more information
and instructions on how to use this attachment tool, go to http://www.ssw.com.au/SSW/Database/AttachmentManagerOverview.asp
Approximate installation time: 2 minutes
9. Once the Database has been reattached, close the application and
restart to invoke SSW Data PRO SQL. This will upgrade the data structures to
the current SQL Version.
Approximate installation time: 3 minutes
10. Finished - You now have the current version of the Data Structure, with Tennis PRO! For help on getting started see www.ssw.com.au/TennisPRO/Documentation
