1 / 16

Introducing TCM 9.0 featuring SQL Server

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

jalene
Download Presentation

Introducing TCM 9.0 featuring SQL Server

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introducing TCM 9.0featuring SQL Server Brian BixbyRichard KokoskiRandy Lott

  2. Agenda • TCM 9.0 Deliver Timeline • SQL Server 2005 • Conversion • Installation • Custom Reports • Utilities • SQL Server Best Practices • Q&A

  3. TCM 9.0 Delivery Timeline • Beta begins March 2008 • Controlled Release begins April 2008 • General Availability in May 2008

  4. 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

  5. What is SQL? • Structured Query Language (SQL) programming language • Database engine • Microsoft SQL Server 2005 Family

  6. Why use MSSQL? • Enhanced performance (speed) • Larger database size (4gb+) • Stronger development platform • Stability • Industry standard

  7. What version of SQL to use? • SQL Server 2005 Express w/SQL Server Management console. • SQL Server 2005 Standard

  8. Conversion Preparation • Post all batches in all modules. • Clear Users • Repair and Compact database • Backup database locally and offsite

  9. Printing Reports • Printing reports • GL – Trial Balance • GL – Financial Reports • AP – Vendor Analysis • AP – Open Payables by Vendor • AP Open Payables by Period End

  10. Reports continued • AR – Aged Trial Balance • AR – Retention Due Listing • JC – Bonding report • JC – Cost to Date Summary by Type • JC – Cost History

  11. 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

  12. Installation Preparation • Pre-requisites for installation • Hardware requirements • TCM access version 8.9 must be uninstalled before installing TCM 9.0

  13. 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”

  14. Installation • Then TCM will load forms, reports and help.

  15. Custom Reports • Updating Crystal Reports • Updating Access Reports • Updating Excel Queries

  16. Utilities • Most of the utility functions will now be handled by SQL Server 2005.

More Related