The following table shows the required version for the Enterprise SQL Server Database for each client version.

The SQL Server is always backwards compatible with AgWare Client software.  That allows the server to be updated before users run the Client install.  However, if a client is updated before the server users will not be able to search the database for sales or post new sales until the server is updated to the required version.

If you are a IT Administrator and need the scripts to update your server please e-mail support@uaar.net to request the download link and update instructions.

Client Version Server Version
5.0.3 Required: 3.3.2
Recommended: 3.3.3
4.3.2 Required: 3.2.22
Recommended: 3.2.28
4.2.12 Required: 3.2.22
Recommended: 3.2.24
4.2.8 Required: 3.2.22
Recommended: 3.2.24
4.2.4 Required 3.2.22
4.1.5 Required: 3.2.15
Recommended: 3.2.18
4.0.13 Required: 3.2.15
Recommended: 3.2.18
4.0.1 3.2.15
3.3.6 3.2.14
3.3.2 3.2.13
3.2.9 3.2.12
3.2.7 3.2.11
3.2.5 3.2.8
3.2.2 3.2.7
3.1.1 3.2.4
3.0.1 3.2.3

Change Log for Database Scripts

 Script Version Description 
3.3.3
  • Changed how Appraisals are uploaded to increase performance.
3.3.2
  • Change how attachments are downloaded to increase performance
3.3.1
  • Update PostRecord stored procedure to work better with FireDac
3.2.28
  • Fix bug that caused the sizes of un-downloaded attachments to be incorrect.
3.2.27
  • Add a stored procedure for adding attachments to existing sales
3.2.26
  • Fix bugs affecting posting appraisals when fields were too long
3.2.25
  • Add support for “Analyse Income” report.
3.2.24
  • Fix bug in GetSaleXML
3.2.23
  • Add additional field to the Appraisal tables.
3.2.22
  • Added new tables for Saved Comments that will be pushed out to ClickForms.
3.2.21
  • Added anew KMLPresent field for use in the Sales Grid.
3.2.20
  • Changed Datatype used for KML field in FlatSale
3.2.19
  • Added a new KML field to the SaleMap table for storing property boundaries.
3.2.18
  • This script is not required for a DataLog client update.
  • Removes (if present) duplicate MapPoints for sales that can cause a sale to appear twice in search results.
  • Adds an unique table constraint to prevent future duplicate MapPoints for a single sale.
3.2.17
  • This script is not required for a DataLog client update.
  • Speeds up the loading of list choices on the Enterprise search screens by removing unneeded table joins from the access views in the database.
3.2.16
  • This script is not required for a DataLog client update.
  • Fixes a bug in the mapping of ClickFORMS Appraisal data.  Township data was being put into the Highest and Best Improved field and zip code data was placed in the section field.
3.2.15
  • Updates the Post procedure to correctly handle unicode strings from DataLog
3.2.14
  • Changes for the Permanent Planting Tables
  • Add Columns YearPlanted, PlantingAcres, RcnAcres, DepreciationDollarTotal, DepreciationDollarPerYear, DepreciationPhysicalPercentTotal, DepreciationPhysicalPercentPerYear, and DepreciationOtherPercentTotal to the SalePermP table
  • Add New Column IncomePrice to the SaleIncomeTotals Table
3.2.13
  •  Alter view FlatSale to include the SaleMap.SalePoint geography column as SalePoint
3.2.12
  •  Add the Post date of the sale to the data returned by an enterprise search.  The user can add this data to the grid using the “File Modify Data” column.
3.2.11
  • Add the Long/Lat fields to table FieldReferenceClassEx
  • Update table FieldReferenceClassEx setting the DataSize to 2 for the State attribute of the GrantorDetails and GranteeDetails nodes
  • Update the Response Fingerprint row in table SystemConfiguration because of the changes to table FieldReferenceClassEx
3.2.10
  • Create the FTSearchCatalog fulltext catalog
  • Create a fulltext index on the CommentText column in the SaleComment table
  • Create function GetFTSearchSaleIds
3.2.9
  • Add Timber to table LandQualityClass
  • Update the Response Fingerprint row in table SystemConfiguration because of the changes to table LandQualityClass
3.2.8
  • Add the missing SaleIncomeTotals fields to table FieldReferenceClassEx
  • Update table FieldReferenceClassEx setting the NodeName to SaleIncomeTotals for the SourceIsActual field
  • Add Timber to table LandUseClass
  • Add YieldRate column to SaleIncomeTotals tables and update stored procedures
  • Update the Response Fingerprint row
 3.2.7
  • Alter procedure WriteRecord to rollback the transaction if an error occurs
  • Alter procedure PostRecord to remove unnecessary rollback
  • Alter view FlatSale to include the SaleLandTotals.TotalDeededDollarPerAcre field
 3.2.6
  • Make the PersonAddress.StateId column nullable
  • Alter view FlatSale to include Mail Merge fields
 3.2.5a
  • Create the new Permanent Planting tables (SalePermP) Existing Improvement Data is converted.
  • Alter view FlatSale to include the SalePermPTotals table
  • Delete existing Improvement based Permanent Planting tables and fields
  • Grant execute permission for stored procedure WriteAppraisalFiles to the UAAR_User role
  • Change the Depreciation Percentage columns data type from int to money in SaleImprovement
  • Create the new Financing Details tables
  • Create the new PersonAddress tables
  • Create the SaleMap table
  • Update table FieldReferenceClassEx setting the DataVersion to 4 for all new SalePermP, FinancingDetails, and PersonAddress fields
  • Update the Response Fingerprint row
 3.2.4
  • Drop all the response X tables trigger to update the Response Fingerprint row in table SystemConfiguration
  • Create procedure UpdateResponseFingerprint
 3.2.3
  • Add table SecondaryPropertyType
  • Add table SecondaryLandUse
  • Add View SaleAllPropertyTypesView
  • Add View SaleAllLandUsesView
3.2.2
  • Revoke execute on DeleteSale to UAAR_User
  • Add the Post Appraisal CLK Files row to table SystemConfiguration
  • Rename table AppraisalPDF to AppraisalFiles
  • Add new CLK columns to table AppraisalFiles
  • Drop procedure WriteAppraisalXMLHolder
  • Create procedure WriteAppraisalFilesHolder
  • Create procedure WriteAppraisalXML
  • Alter procedure PostAppraisal
  • Alter procedure WriteAppraisalFiles
  • Alter procedure DeleteAppraisal
 3.2.1
  • Add column UnitTypeName to table RangeImprovement
  • Add table SaleAllocation
  • Create the new Permanent Planting Type tables
  • Add table ImprovementPermP
  • Add table PermPSubVariety
  • Add the Permanent Planting row to the ImprovementKindClass table
  • Set the PrintOrder to -1 for rows with a ChildNodeName in the FieldReferenceClassEx table
  • Add Permanent Planting fields to table FieldReferenceClassEx
  • Alter procedure GetSaleXML for the new Permanent Planting tables
  • Add View ImprovementPermPAllVarietiesAccessView
 3.2.0
  • Create procedure FindRangeEntryKeys
  • Add Improvement TotalLife fields to table FieldReferenceClassEx
  • Update the Response Fingerprint row