160 likes | 291 Views
Introducing TCM 9.0 featuring SQL Server. Brian Bixby Richard Kokoski Randy Lott. Agenda. TCM 9.0 Deliver Timeline SQL Server 2005 Conversion Installation Custom Reports Utilities SQL Server Best Practices Q&A. TCM 9.0 Delivery Timeline. Beta begins March 2008
E N D
Introducing TCM 9.0featuring SQL Server Brian BixbyRichard KokoskiRandy Lott
Agenda • TCM 9.0 Deliver Timeline • SQL Server 2005 • Conversion • Installation • Custom Reports • Utilities • SQL Server Best Practices • Q&A
TCM 9.0 Delivery Timeline • Beta begins March 2008 • Controlled Release begins April 2008 • General Availability in May 2008
The Construction Manager 9.0Microsoft SQL Server 2005 What is SQL? Why SQL? What version of SQL Conversion preparation in TCM Printing Reports Hardware requirements Installation preparation Installation Conversion Custom Reports Utilities
What is SQL? • Structured Query Language (SQL) programming language • Database engine • Microsoft SQL Server 2005 Family
Why use MSSQL? • Enhanced performance (speed) • Larger database size (4gb+) • Stronger development platform • Stability • Industry standard
What version of SQL to use? • SQL Server 2005 Express w/SQL Server Management console. • SQL Server 2005 Standard
Conversion Preparation • Post all batches in all modules. • Clear Users • Repair and Compact database • Backup database locally and offsite
Printing Reports • Printing reports • GL – Trial Balance • GL – Financial Reports • AP – Vendor Analysis • AP – Open Payables by Vendor • AP Open Payables by Period End
Reports continued • AR – Aged Trial Balance • AR – Retention Due Listing • JC – Bonding report • JC – Cost to Date Summary by Type • JC – Cost History
Reports continued • PY – Quarterly Reports • QTD/YTD Earnings Register • State, Local and Disability Tax • 941, SUTA, reports from GEMM • Deduction Reports • Union Reports • Insurance Reports
Installation Preparation • Pre-requisites for installation • Hardware requirements • TCM access version 8.9 must be uninstalled before installing TCM 9.0
Installation • Turn off anti-virus programs • Log in as Administrator • Microsoft SQL Server 2005 Express will install automatically if the installation does not detect any version of SQL Server 2005. • Installation will install a SQL database on your “Server”
Installation • Then TCM will load forms, reports and help.
Custom Reports • Updating Crystal Reports • Updating Access Reports • Updating Excel Queries
Utilities • Most of the utility functions will now be handled by SQL Server 2005.