CounterPoint SQL V8.3.5 Release Notes
Microsoft SQL Server 2005
CounterPoint SQL now supports Microsoft SQL Server (MSSQL) 2005 Enterprise Edition and Standard Edition, as well as SQL Server 2005 Express Edition (SSE).
SQL Server 2005 Express Edition, which is included with CounterPoint, replaces Microsoft SQL Server 2000 Desktop Engine (MSDE). While MSDE could only support databases of up to 2 GB, SSE supports databases of up to 4 GB.
CounterPoint SQL Express still has a database limit of 2 GB.
Further, SSE allows you to use Microsoft’s graphical database management tool, SQL Server Management Studio Express (SSMSE), to manage your database(s), instead of requiring you to use OSQL commands. SSMSE is also included with CounterPoint.
MSSQL 2005 Enterprise Edition and Standard Edition are purchased separately.
MSSQL 2005 and SSE require Windows Installer 3.1 and .NET Framework 2.0. To use CounterPoint’s Upgrade Data utility or any of CounterPoint’s export accounting interfaces, you must also install the SQL Server 2000 Data Transformation Services (DTS) runtime. All of these components are included on the CounterPoint DVD.
Refer to the CounterPoint SQL Installation Guide for detailed information about installing SSE, along with its pre-requisite components, on a new CounterPoint system. Refer to the CounterPoint SQL Update Guide for complete instructions for updating an existing CounterPoint system to SSE.
If you are updating from a previous version of CounterPoint, you must run the mssql2005conversion.sql script after you perform the update to convert your existing CounterPoint database(s) to the MSSQL 2005 format.
CounterPoint software download
You can now download the latest version of CounterPoint SQL from the CounterPoint website (http://www.counterpointpos.com/support/downloads cpv8.htm).
You must be a registered CounterPoint Subscription Service (CSS) subscriber to download software from the Support area of the CounterPoint website.
To download CounterPoint, log in to the Support area of the CounterPoint website using your CounterPoint Serial #, browse to the CounterPoint SQL Downloads page, and then select one of the following options:
Complete – An image file of the entire contents of the CounterPoint DVD, including the CounterPoint software, Microsoft SQL Server 2005 Express Edition (SSE), the DataXtend Replication Engine (DXRE), and other third-party components.
Update – A self-extracting archive that contains only the components that are necessary to update CounterPoint to the latest version.
If you are updating from a previous version of CounterPoint and you would like to upgrade to MSSQL 2005 or SSE, you must download the Complete DVD image, as described in the CounterPoint SQL Update Guide.