Conductor4SQL Release Notes

2021 Release Notes

Version 3.7.4.0 (2021-09-17) Changes

CONSQL-2143 Fixed: Need to manually reapply existing Conductor4SQL license after upgrading to version 3.7.3.0
CONSQL-2166 Fixed: Scheduled fails on prepare step when two tables with same name and different schema exist
CONSQL-2167 Fixed: Sync database checker does not take table schema into consideration
CONSQL-2168 Fixed: Client side procedure dbo.CL_Conversation_Resend_SP fails when the instance is a named instance
CONSQL-2171 Fixed: Push sync consolidation wizard not working
CONSQL-2172 Fixed: Scheduled commands and queries sometimes break when upgrading to version 3.7.3.0 of Conductor4SQL
CONSQL-2173 Fixed: Outstanding get changes for a table when disabling a table results in the central queue going down
CONSQL-2174 Fixed: Optimise email C4SQL - Data Sync Errors
CONSQL-2175 Fixed: Synced databases are detected as removed when database name is in different case
CONSQL-2182 Fixed: Changing primary key datatype size not getting detected as a primary key change
CONSQL-2184 Fixed: Cater for blank PrimaryKeyOrdinal='' entries in the table TableMetaData column in dbo.CL_Client_Data_Sync_Tables_Detail
CONSQL-2186 Fixed: Install on SQL Server 2008 and 2005 fails on reinstall with existing certificate files
CONSQL-2187 Fixed: Push sync does not cater for changing primary keys when using a one-to-one mapping
CONSQL-2189 Fixed: Once off sync fails if columns contains SQL Server keywords
CONSQL-2191 Fixed: Resending System queries is failing on the Client Queue on the client side
CONSQL-2193 Fixed: Instances not getting installed with "Event notifications" even when option "Event Notification Enabled On Client Install" is enabled
CONSQL-2194 Fixed: Central report processing failing to process database file information when DatabaseFileName is very long
CONSQL-2200 Fixed: Remove Hummdb jobs from Conductor4SQL install and upgrades
CONSQL-2201 Fixed: Realtime sync update issue when column_id does not match ordinal_position
CONSQL-2202 Fixed: Cannot uninstalled Conductor4SQL central when installed on a named instance
CONSQL-2203 Fixed: Central message check no longer showing reason for opening message failure on client install
CONSQL-2204 Fixed: Client installs failing when using Latin1_General_BIN (binary) server level collation
CONSQL-2145 Improvement: ClientID data sync column needs to be renamed to C4SQL_ClientID in central synced tables
CONSQL-2164 Improvement: Create new standard report called Conductor4SQL - Data Sync Summary
CONSQL-2181 Improvement: Change primary key on table dbo.CL_Client_Data_Sync_Tables_Detail to reduce blocking
CONSQL-2188 Improvement: Make client install SQL timeout configurable
CONSQL-2199 Improvement: Allow Conductor4SQL to launch the SQLPro web application

2020 Release Notes

Version 3.7.3.0 (2020-11-11) Changes

CONSQL-2152 Fixed: Client bulk prechecker never timing out
CONSQL-2150 Fixed: syncworx_endpoint is owned by the user installing Conductor4SQL on a client rather than login SyncWorxAdmin user or Service Account user
CONSQL-2141 Fixed: Scheduled sync table structure changes shouldn't come through via client server trigger C4SQL_DDL_Event
CONSQL-2140 Fixed: When data sync datatypes change to a non-character type, original collation must be discarded
CONSQL-2134 Fixed: Latest Windows update (2020-07-14) breaks Conductor4SQL save to table and send email results
CONSQL-2120 Fixed: When upgrading Conductor4SQL some Scheduled sync tables stop syncing
CONSQL-2128 Fixed: Getting false positive push sync errors in email alerts
CONSQL-2132 Fixed: Push sync tables getting detected as missing data sync objects
CONSQL-2112 Fixed: When using push sync with consolidation table is getting truncated
CONSQL-2130 Fixed: PowerBI Source control no longer generating a valid PowerBI file
CONSQL-2129 Fixed: Backup monitoring report email results in 'Arithmetic overflow error converting numeric to data type numeric'
CONSQL-2118 Fixed: Conductor4SQL report queries shouldn't work if the Conductor4SQL license has expired
CONSQL-2116 Fixed: Handle duplicate Job Names in Job report data
CONSQL-2110 Fixed: Data sync issue when both normal sync and push sync are enabled for a table
CONSQL-2147 Improvement: Allow one-to-one mappings for regular (Scheduled, Enterprise, Once-Off) sync to exclude the ClientID and C4SqlClientDatabaseName columns
CONSQL-2136 Improvement: Add support for changing table structure (including primary keys) when using 1-1 database mappings
CONSQL-2142 Improvement: Detect if primary keys or data sync types change in scheduled sync
CONSQL-2127 Improvement: Allow email attachments to be xlsx or csv file extensions
CONSQL-2135 Improvement: Import Central Certificate when upgrading Conductor4SQL Central
CONSQL-2133 Improvement: Remove Windows Administrator user requirement from Conductor4SQL install
CONSQL-2074 Improvement: Allow configuring display of business attribute columns when emailing query results
CONSQL-2131 Improvement: Reduce the number of rows per iteration that scheduled sync processes
CONSQL-2126 Improvement: Conductor4SQL service needs to detect if there are messages stuck on the transmission queue
CONSQL-2125 Improvement: Conductor4SQL Service needs to check if SyncWorx database has been restored
CONSQL-2124 Improvement: Conductor4SQL Service needs to check if msdb database is suspect
CONSQL-2123 Improvement: Allow Conductor4SQL Windows Service to run in Debug mode
CONSQL-2108 Improvement: Add license key guid to Conductor4SQL - System Information

Version 3.7.2.2 (2020-03-24) Changes

CONSQL-2106 Fixed: Cannot create scheduled sync staging database if old staging database files still exist in filesystem
CONSQL-2105 Fixed: Bit columns changed between 1 and null not captured
CONSQL-2103 Fixed: We don't sync additional rows if all columns are null except for the primary key
CONSQL-2104 Fixed: Scheduled sync bug when resyncing tables with reattached staging database
Fixed: Collation error in scheduled.CL_Get_Scheduled_Changes_Internal

Version 3.7.2.1 (2020-01-29) Changes

CONSQL-2097 Fixed: Issue in data sync pulse check where if there is an error with one datasync type the others show as an error
CONSQL-2096 Fixed: CL_CDC_Database_Checks sometimes fails if there are spaces or dashes in the database name
CONSQL-2064 Fixed: Column alter, drop and add not reflecting in the client side in dbo.CL_Client_Data_Sync_Tables_Detail.TableMetaData for Realtime and Enterprise sync
CONSQL-2101 Fixed: Conductor4SQL - Data Sync Differences report is missing Push sync
CONSQL-2102 Fixed: Scheduled sync bug when data type is NUMERIC(1,0) or DECIMAL(1,0)
Fixed: Push sync breaks after upgrade from version 3.7.1.3
CONSQL-2100 Improvement: Add weekly alert email with license and statistics information
CONSQL-2099 Improvement: Add flag AllowCircularSync

Older Release Notes

Version 3.7.2.0 (2019-12-17) Changes

CONSQL-2048 Cancel user query/command has collation issues
CONSQL-2091 Adding columns to a push sync table should not add the columns in the central source table
CONSQL-2089 If we recreate Client Queue conversation we don't always use the new conversation
CONSQL-2086 Removing a get scheduled sync changes message should not mark sync for the table as disabled
CONSQL-2084 Pulse check shouldn't fail in C4SQL_Staging_ database is not online
CONSQL-2078 Central Queue Errors show blank errors when queues are off due to queue processing limits
CONSQL-2076 Issue with push sync when pushing to more than one client and ddl changes have occurred
CONSQL-2075 Scheduled sync doesn't pick up values for changes if your change is a default value
CONSQL-2073 If there are square brackets inside a column name the save to table feature fails
CONSQL-2070 New columns not getting added at target when using push sync
CONSQL-2072 The log space monitoring part of the pulse check doesn't allow for more than one log file
CONSQL-2069 Loosing latest batch of changes when adding/removing/altering a table synced with Enterprise Sync
CONSQL-2060 Reports missing flag isn't flagged when client report gathering fails
CONSQL-2061 SyncWorx high log space email subject should not be "Data Sync Error"
CONSQL-2063 Auto enable queues fails if queue error message is longer than 255 characters
CONSQL-2059 CDC is disabled for databases that are not syncing when uninstalling client
CONSQL-2058 Data sync backup client side backup and resend messages not working
CONSQL-2057 When index rebuild fails in Daily Job cannot see the index that it failed on
CONSQL-2056 Adding column with the same name but different case results in an infinite loop when processing at central
CONSQL-2054 Cannot upgrade from version 3.7.1.3 to current version
CONSQL-2046 Incorrect textbox label on user query scheduler
CONSQL-2052 Cannot disable scheduled sync if C4SQL_Staging database has been dropped
CONSQL-2051 Daily job not disabling the ExecuteTokens when disabling queues
CONSQL-2034 Allow toggling of html body and csv attachment for scheduled query email results
CONSQL-2047 Once off sync creates an invalid primary key on Central
CONSQL-2042 Report issue: Transaction Log backups make the "Database Files Details" report fail
CONSQL-2041 Central table create script has incorrect primary key for C4Sql_PBI.CM_Report_Client_Jobs_Summary_Latest
CONSQL-2021 If auditing is disabled it is flagged as an error on the dashboard
CONSQL-2019 In scheduled sync the timestamp column should not be compared
CONSQL-2020 In Scheduled Sync: If table has no columns outside of the primary key all rows are detected as updates
CONSQL-2027 If no tables are syncing under the Default_Datasync_Queue, "Scheduled Sync" job results in error
CONSQL-1998 Collation and indexes issue with Scheduled and Enterprise sync when syncing tables with varchar primary keys
CONSQL-2022 Total Row Count counters wrong when using skip initial sync
CONSQL-2029 Null object error on Client Data Sync Monitoring Screen
CONSQL-2030 Scheduled sync errors are not correctly showing on the dashboard
CONSQL-2033 Script name no longer pulling through when sending scripts (user command/query)
CONSQL-2032 Data Sync Errors email Log Space Error section giving false positives
CONSQL-2015 SyncWorx no longer being created in SIMPLE recovery at client
Fixed: Cannot upgrade client if client is using another login other than SyncWorxAdmin
Fixed: Adjusted Conductor4SQL License will expire in x days email alert to only alert daily and not hourly
Fixed: Change scripts 3.7.1.7 and 3.7.1.8 are not running as part of upgrade
CONSQL-2093 Add business attributes to the User Command/Query Details Tab
CONSQL-2088 Checking table checksum's manually should have a time to live
CONSQL-2087 Create procedure to sync structure of source table and C4SQL_Staging table structure
CONSQL-2079 Central queue enable function of hourly job needs to be in its own job
CONSQL-2071 Dashboard data sync query for data sync errors taking a very long time to complete
CONSQL-2066 Add daily alert for when Conductor4SQL License will expire in x days
CONSQL-2062 Cannot schedule File Pull from SQL Server Job
CONSQL-2055 Add max number of processing queues limit to data sync queue processor
CONSQL-2050 Function dbo.CM_GetCentralQueueCountSummary_FN running very slowly
CONSQL-2049 Deadlock when running procedure C4SqlConfig.Client_Queues_Notification
CONSQL-2044 Stored procedure dbo.CM_Get_Database_Mapping_Information extremely slow
CONSQL-2040 Get scheduled changes messages should be able to use other queues other than the Default_Datasync_Queue
CONSQL-2038 Delete old change scripts
CONSQL-2012 Add logic to only send "Get Changes" if previous message was completed
CONSQL-2017 Show for how many clients results were received in "Send Results as Email"
CONSQL-2024 Scheduled Sync: Replication re-initialization
CONSQL-2023 Add column C4SQL_LastUpdated to all synced tables
CONSQL-2026 Add flags to allow disabling Data Sync Audit and Message Audit
CONSQL-2031 Missing index on ClientID on table dbo.SB_Config
CONSQL-996 Set same default database collation at central as at client
CONSQL-2016 The clients behind boxes should be configurable
CONSQL-2028 Make the batch size for initial sync configurable
CONSQL-2035 Conductor4SQL - Space Monitoring email missing column heading
CONSQL-2013 Limit the number of data sync queues that can execute at once on central
CONSQL-1143 Add option to cancel user commands and queries
CONSQL-2025 Allow bulk update of database mappings
CONSQL-519 Allow bulk editing of client business attributes
CONSQL-2085 Use database and dynamic database name should allow a comma separated list of database names

Version 3.7.1.5 (2019-05-02) Changes

CONSQL-1992 Feature: Add ability to auto re-enable queues on certain errors
CONSQL-1999 Feature: Add a "Send Test", "Send Test Email" and "Save Test File" buttons to scheduled query and change save format to CSV
CONSQL-1964 Improvement: Optimise data sync processor logic by persisting the temp table between calls
CONSQL-1969 Improvement: Add business attribute columns to: create data sync table - Client Server dropdown menu
CONSQL-1971 Improvement: When refreshing dashboard the CM_Update_Dashboard_UI_SP proc is taking forever to complete
CONSQL-1974 Improvement: Upgrade DevExpress to v18.2.4 from v18.1.7
CONSQL-1975 Improvement: Add central and client side SQL functions for getting ClientName, ClientID and client business attributes
CONSQL-1982 Improvement: When creating sync tables add an index to optimise deletes
CONSQL-1983 Improvement: Alerts Screen - Add the ability to update/change email address
CONSQL-1984 Improvement: Remove Backup Summary from Conductor4SQL - Backup Monitoring
CONSQL-1985 Improvement: Remove the persistent PowerBI Report tables
CONSQL-1994 Improvement: Staging database in scheduled sync should be created on the same drive as the source database
CONSQL-2005 Improvement: No way to see what push table get changes were skipped due to missing CDC objects
CONSQL-2010 Improvement: Add the ability to get push sync changes from UI
CONSQL-1959 Bug Fix: Client side DDL change tracking triggers cause Alter Table statements to fail if login has limited privileges
CONSQL-1967 Bug Fix: "Read only user" no longer works correctly
CONSQL-1976 Bug Fix: Conductor4SQL client installation no longer works with existing service broker endpoints
CONSQL-1977 Bug Fix: Central Client Control -> System Command Status screen, the details grid does not dock properly
CONSQL-1978 Bug Fix: Bulk client prechecker does not show all errors if there is more than one
CONSQL-1979 Bug Fix: Conductor4SQL no longer writing log files
CONSQL-1980 Bug Fix: When no clients are installed most Central buttons/tabs should be disabled
CONSQL-1981 Bug Fix: Cannot drag Conductor4SQL main window when window is full screen
CONSQL-1987 Bug Fix: When Assigning Group Data Sync, You need to double click a group before it updates the group name
CONSQL-1988 Bug Fix: Change identity on Data sync audit and default audit table to bigint instead of int
CONSQL-1991 Bug Fix: DDL Changes on push sync getting meta data for wrong table
CONSQL-1993 Bug Fix: When getting scheduled changes the following error is raise in certain scenarios "Could not continue scan with NOLOCK due to data movement."
CONSQL-1995 Bug Fix: If Scheduled sync fails anywhere on initialisation it doesn't resume properly
CONSQL-1996 Bug Fix: Checksums are not matching for the Time data type
CONSQL-1997 Bug Fix: Push data sync not creating column C4SqlCentralDatabaseName
CONSQL-2000 Bug Fix: Add missing non-clustered index on column SqlCommandDate on CM_Client_Data_Sync_Log
CONSQL-2003 Bug Fix: Upgrade from 3.7.1.3 and up creates multiple schedules
CONSQL-2004 Bug Fix: Warning for unsupported type sql_variant not showing for Push Sync
CONSQL-2006 Bug Fix: Right-click->"Open client" should not show in Push Sync Error details on dashboard indicator
CONSQL-2007 Bug Fix: Single client uninstall not closing when complete
CONSQL-2009 Bug Fix: When assigning push sync the message says "Enabling Real-time"
CONSQL-2011 Bug Fix: Testing a scheduled query "Save to file" with no result need a better error message

Version 3.7.1.4 (2018-12-18) Changes

CONSQL-1906 Feature: Script Editor Screen redesign
CONSQL-1937 Feature: Main/Central Screen redesign
CONSQL-1941 Feature: Scheduled save scheduled query results to file
CONSQL-1942 Feature: Add support for multiple schedules for scheduled sync
CONSQL-1949 Feature: Inject the full table name in ErrorMessage column in SB_Error where applicable
CONSQL-1682 Improvement: Dashboard refresh speed very slow
CONSQL-1901 Improvement: Move data sync types order to make Scheduled Sync the default data sync type
CONSQL-1902 Improvement: When enabling/resyncing table automatically add additional columns and widen existing columns
CONSQL-1903 Improvement: Add database level trigger on Scheduled Sync tables to adjust CT and Staging table when source table change
CONSQL-1904 Improvement: Upgrade Enterprise Sync to DataSync version 2
CONSQL-1905 Improvement: Upgrade Once-Off Sync to DataSync version 2
CONSQL-1907 Improvement: Modernize the central dashboard
CONSQL-1913 Improvement: Push data sync should truncate the table instead of batch delete whenever possible
CONSQL-1917 Improvement: Change magnifying glass icon to something more appropriate to open central or client console
CONSQL-1924 Improvement: Added a email alert for Push Sync errors "Conductor4SQL - Push Data Sync Errors"
CONSQL-1922 Improvement: Improve build speed
CONSQL-1925 Improvement: Push sync needs to skip tables where either the CT table is missing or if CDC has been disabled
CONSQL-1926 Improvement: Enterprise Sync client monitoring needs to be built in
CONSQL-1927 Improvement: Split pulse check into "Pulse Check" and "Data Sync Pulse Check"* Cleanup dbo.CM_Central_Queue_Process_Message_SP
CONSQL-1931 Improvement: When uninstalling a client with remove data should use batch deletes for data deletion
CONSQL-1933 Improvement: Optimize the "Database Mappings For X" screen to load much faster
CONSQL-1888 Improvement: Upgrade UI to Devexpress version v18.1.5
CONSQL-1889 Improvement: Replace Please Wait popup screen with new "Overlay Wait Form"
CONSQL-1894 Bug Fix: When deleting the first business attribute the business attributes are not saved to the correct attribute
CONSQL-1900 Bug Fix: The product don't support data type sql_variant in any of data sync types make sure its explicitly excluded
CONSQL-1919 Bug Fix: Scheduled Sync error messages never clearing at client side
CONSQL-1920 Bug Fix: Scheduled sync only gets first 5 million table changes
CONSQL-1932 Bug Fix: When syncing a large table using Enterprise Sync that table gets marked as missing data sync objects
CONSQL-1934 Bug Fix: Ensure that central upgrades do not reset the schedules of the C4SQL Jobs
CONSQL-1938 Bug Fix: Scheduled Sync sometimes returning the following error "Could not complete cursor operation because the table schema changed after the cursor was declared."
CONSQL-1953 Bug Fix: SQL Diff screen text colors not working well with a dark themed skin
CONSQL-1945 Bug Fix: Sql Command timeout too short when sending system commands
CONSQL-1946 Bug Fix: Client Last Sync Date not updating when no data sync changes in Scheduled and Enterprise Sync
CONSQL-1948 Bug Fix: Bulk Installer/Uninstaller screen buttons not sized properly
CONSQL-1950 Bug Fix: Add back the check for open ports
CONSQL-1952 Bug Fix: Skin Issues with the Create/Edit Email lists screen and create/edit schedule screen
CONSQL-1954 Bug Fix: Date/Time fields on Central Client Overview Displaying incorrectly
CONSQL-1962 CONSQL-1966 Bug Fix: General UI bug fixes
CONSQL-1965 Bug Fix: File pull no longer works

Version 3.7.1.3 (2018-09-20) Changes

CONSQL-1868 Improvement: Rework Scheduled sync to use less tempdb space, increase performance and support all data types
CONSQL-1895 Improvement: Improved speed of central client control screen
CONSQL-1891 Improvement: Improved pulse check speed for checking for outstanding pulse checks
CONSQL-1856 Improvement: Add right click context menu options to auditing screens
CONSQL-1886 Improvement: Binary data type not supported in the following data sync types: Push, Scheduled, Enterprise Scheduled
CONSQL-1875 Improvement: The CM_System_%, CM_Reverse_%, CM_Removed_Client_Data_% tables are no longer created as they are no longer needed
CONSQL-1871 Improvement: Add administration screen for editing email alert configurations
CONSQL-1869 Improvement: Preserve state (filter, columns and ordering) of grids in Central Client Control when switching between tabs
CONSQL-1651 Improvement: Enlarge the "Send A System Command" menu to display all context menu options
CONSQL-1870 Improvement: Allow configuration of "Client Connection Network Packet Size" to handle poor networks better when installing clients
CONSQL-1896 Bug Fix: Scheduled Sync does not work correctly when a table is consolidated but has different definitions
CONSQL-1892 Bug Fix: Disallow circular data sync
CONSQL-1880 Bug Fix: Meta data compare failing with error when attempting to fix errors
CONSQL-1885 Bug Fix: XML parsing error when trying to calculate checksum on tables and column names with special characters
CONSQL-1883 Bug Fix: Data sync message types "Initial Data Sync", "Data Sync" and "Table Metadata" coming through as "Unknown" in Client Dashboard screen
CONSQL-1881 Bug Fix: Loosing precision on float data type in scheduled and push sync
CONSQL-1873 Bug Fix: Checksum issues around previously unsupported data types

Version 3.7.1.2 (2018-07-19) Changes

Improvement: Improved system information retrieval and reporting
Improvement: Push sync uses a single capture instance
Improvement: Enterprise Sync DDL changes audited for better change related inconsistencies
Improvement: Power BI report data inserted into persistent tables to speed up the PowerBI reloads
Improvement: Various Power BI dashboard new features and improvements
Improvement: Monitoring of CDC and SQL Replication processes when push sync enabled
Improvement: Various Push Sync performance improvements
Improvement: Database Mapping Name selection enhanced in Data Sync Table Management tab
Improvement: Improved auditing of initial sync start and end times
Improvement: Truncate used instead of delete where possible when deleting sync data on central server
Improvement: ALTER_SERVER_CONFIGURATION included in standard auditing
Bug Fix: Improved handling of dropping and recreating calculated columns in push data sync
Bug Fix: Push sync partial initial sync table to complete before getting changes
Bug Fix: Information updating correctly in Data Sync Monitoring screen
Bug Fix: Database mappings case sensitivity resolved
Bug Fix: Bulk Installer error message length issue
Bug Fix: Duplicate sync messages handled
Bug Fix: Checksums failed when push sync enabled
Bug Fix: Real-time and scheduled sync fails when default collation is different from sync database

Version 3.7.1.1 (2018-04-24) Changes

CONSQL-1765 Feature: Add wizard for one-to-one push data sync
CONSQL-1766 Feature: Add wizard for consolidation push data sync
CONSQL-1771 Improvement: Change central data deleting to use batch deletes outside of a transaction
CONSQL-1722 Improvement: Failed job email needs to only send if the job recently Failed_Job_Monitoring
CONSQL-1751 Bug Fix: Get "Database File Details" report gathering failing
CONSQL-1772 Bug Fix: Central progress column is getting updates for all tables for a client during Enterprise Sync initial sync
CONSQL-1762 Bug Fix: User query no result set results a .net error
CONSQL-1775 Bug Fix: Conductor4SQL Service logging not working
CONSQL-1779 Bug Fix: Getting deadlocks on the internal queue when enabling or disabling Push data sync on multiple queues concurrently
CONSQL-1780 Bug Fix: Deadlocks on client side when simultaneous data sync queues are processing
CONSQL-1781 Bug Fix: Checksum issues in push data sync
CONSQL-1784 Bug Fix: Daily Job Re-Index script not matching primary keys to tables correctly
CONSQL-1792 Bug Fix: Not processing changes when skipping initial sync was used
CONSQL-1778 Bug Fix: Conductor4SQL Windows Service not being created as "Delayed" when using stand-alone installer
CONSQL-1783 Bug Fix: Date data type not supported in scheduled sync
CONSQL-1803 Bug Fix: Initial sync fails on table with 16 columns or more in primary keys
CONSQL-1808 Bug Fix: Data Sync Monitoring screen showing the incorrect information
CONSQL-1791 Bug Fix: Nulls in Failed Job Report resulting in a blank report
CONSQL-1782 Bug Fix: Query result and DDL alert emails not using updated format
CONSQL-1801 Bug Fix: Client installed using windows authentication not working in client dashboard
CONSQL-1800 Bug Fix: Change user query email subject format to default template format
CONSQL-1675 Bug Fix: Routing gets used for default and named instance if both are installed as client
CONSQL-1798 Bug Fix: User query CSV attachment missing decimals for numeric and decimal data type
CONSQL-1789 Bug Fix: Initial push sync fails because database already exists when enabling for the first time on multiple queues at once
CONSQL-1790 Bug Fix: Calculated column definitions not always populating for push data sync
CONSQL-1784 Bug Fix: Daily Job Re-Index script not matching primary keys to tables correctly
CONSQL-1781 Bug Fix: Checksum encoding issues in push data sync
CONSQL-1780 Bug Fix: Deadlocks on client side when simultaneous data sync queues are processing
CONSQL-1787 Improvement: Reduced probability of deadlock when saving query results to table
CONSQL-1802 Improvement: Improvements to Conductor4SQL Windows Service Logging
CONSQL-1794 Improvement: Changing installation credentials back to SyncWorxAdmin auto-completes password
CONSQL-1665 Improvement: Client Checker Service should enable service broker at client if it is disabled
CONSQL-1786 Improvement: Optimize Enterprise Sync Get Changes Message logic

Version 3.7.0.1 (2018-03-13) Changes

Feature: New data sync type called "Push" data sync to push data from central to clients
CONSQL-1731 CONSQL-1732 Improvement: Eliminated a number of deadlock issues and performance issues in Enterprise Sync
CONSQL-1720 Improvement: Added exclusion table [C4SqlConfig].[CM_Client_Data_Sync_Behind_Exclusions] to "Data sync behind" email
CONSQL-1761 Bug Fix: Send to some does not work from Manage Scripts tab

Version 3.6.1.3 (2018-01-15) Changes

CONSQL-1728 Improvement: Space Summary email does not include summary of databases above max file size threshold
CONSQL-1721 Improvement: Space Monitoring email should only be sent with the daily email and not the hourly email
CONSQL-1462 Improvement: User Query save to table needs to support adding additional columns and widening existing columns
CONSQL-1534 Improvement: Added new column "Is Scheduled" to User Command Log and User Query Log tabs in Central Client Control
CONSQL-1724 Improvement: Failed Job Monitoring email has two new sections: "SQL Server Agent Not Running" and "Failed Job Summary"
CONSQL-1710 Improvement: Exclude telemetry_xevents when sending audit events to central to prevent client event spam
CONSQL-1711 Improvement: Added "Max File Size MB" column to "Space Monitoring" email
CONSQL-1353 Improvement: Added Client Side Enterprise Sync Job to process cdc changes if message has not been received from central in 3 hours
CONSQL-1713 Improvement: Central Server File Space Usage should only send in case of low space
CONSQL-1727 Bug Fix: Save to table fails if the number of rows of the result set is divisible by 1000
CONSQL-1712 Bug Fix: Get report data message is not getting to clients when the client has an outstanding pulse check.
CONSQL-1715 Bug Fix: Central dashboard indicator details displays details for clients that have been disabled for a group
CONSQL-1709 Bug Fix: We are missing indexes on many of the Tracker tables
CONSQL-1708 Bug Fix: We should not be able to deactivate an email list that is assigned to one or more scheduled emails or audit alerts

Version 3.6.1.2 (2017-12-13) Changes

CONSQL-1688 Improvement: Optimize the speed of the Database Table report data gathering client stored procedure
CONSQL-1686 Improvement: Move the report data gathering step in the daily job to its own job
CONSQL-1691 Bug Fix: Only attempt to backup the database master key if we created the database master key on client install in the first place
CONSQL-1693 Bug Fix: Central Client Control has inconsistencies on display order for select clients, send script etc
CONSQL-1685 Bug Fix: Duplicate insert issue with client event data
CONSQL-1707 Bug Fix: Client install fails on Set Up Certificate step when installing on Windows Embedded.
CONSQL-1690 Bug Fix: Convert windows version number in "MS SQL Instance Dashboard" report to human readable form
CONSQL-1689 Bug Fix: If i have multiple email addresses in an email list the emails do not get sent out
CONSQL-1687 Bug Fix: We not getting Enterprise sync changes if we have more than one client syncing with Enterprise Sync

Version 3.6.1.1 (2017-11-15) Changes

CONSQL-1650 Improvement: Change central client queue to process 1 message at a time
CONSQL-1684 Bug Fix: Added summary and fixed invalid data in "Backup Monitoring" Email report
CONSQL-1680 Bug Fix: Fix non descriptive datasync Error 'The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.'
CONSQL-1679 Bug Fix: Send file feature does not handling failures correctly
CONSQL-1647 Bug Fix: Job history report doesn't report on jobs that is currently running
CONSQL-1674 Bug Fix: We should be able to schedule the same user command/query under 2 or more schedules
CONSQL-1673 Bug Fix: System information report not working on SQL Version 2008 R2 RTM
CONSQL-1134 Bug Fix: Many Message Audit table messages do not have accurate sent time
CONSQL-1671 Bug Fix: Errors on central report queue must be logged and the queue must be re-enabled
CONSQL-1475 Bug Fix: Bulk installer does not update group list on refresh
CONSQL-1474 Bug Fix: Can change Authentication method AFTER test connectivity for central
CONSQL-1646 Bug Fix: When comparing procs, if the database/schema is missing, we get an "Out of range" error
CONSQL-977 Bug Fix: Only apply error message to first message that is removed
CONSQL-1595 Bug Fix: SQL Editor screen header is "Send Query to All" when opening from Manage Scripts, should say "User Command/Query Script Editor"
CONSQL-1608 Bug Fix: Send User Command/Query to group has incorrect confirmation message
CONSQL-1672 Bug Fix: "Resend Script" option resends to ALL clients for user command and query and not just the clients that were initially selected

Version 3.6.1.0 (2017-11-01) Changes

CONSQL-1603 Improvement: Add configuration settings to skip ping test in client pre-checker
CONSQL-1633 Improvement: Remove requirement of Mixed Mode Authentication when installing clients
CONSQL-1634 Improvement: PowerBI style, layout and colour enhancements
CONSQL-1488 Improvement: Renamed column heading "Mapping Name" to "Database Mapping Name" to add clarity
CONSQL-1641 Bug Fix: Duplicate central queues in client overview screen if client name a subset of another client name
CONSQL-1640 Bug Fix: We exclude the "Save To Table" and "Use Database" properties when sending a script from the manage scripts tab
CONSQL-1636 Bug Fix: Expired User Query brings down the client queue
CONSQL-1635 Bug Fix: Expiry time for scheduled user command and query defaulting to 1 hour instead of never expiring by default
CONSQL-1630 Bug Fix: Scheduled sync and Enterprise sync staging database should use simple recovery
CONSQL-1610 Bug Fix: Cannot sync databases with spaces in its name
CONSQL-1619 Bug Fix: Client Group merge functionality is not merging clients from other groups as expected
CONSQL-1618 Bug Fix: When we schedule a user query/command it is disabled by default

Version 3.6.0.9 (2017-10-23) Changes

CONSQL-1609 Improvement: Shouldn't be able to sync the same table more than once using database mappings
CONSQL-1616 Improvement: Support installing clients with the format hostname,port
CONSQL-1631 Improvement: Adjust script editor option "Submit and send another script" to be unchecked by default
CONSQL-1604 Improvement: Backup Behind email report should include the "Database File Type" and the "Backup Type"
CONSQL-1615 Bug Fix: Missing Data Sync Objects never clears when data sync fails on the enable step for Enterprise and Scheduled sync
CONSQL-1632 Bug Fix: In meta data compare the "please wait" dialog box does not disappear
CONSQL-1386 Bug Fix: Required business attributes is not enforced in the Bulk Installer
CONSQL-1594 Bug Fix: We missing a refresh before showing the "Data Sync Options" dialog
CONSQL-1612 Bug Fix: If there are no Templates available we shouldn't have the menu option available in Send User Command
CONSQL-1448 Bug Fix: Scheduled sync not excluding columns that are unsupported datatypes
CONSQL-1611 Bug Fix: When selecting the "Edit Default Email Settings" option we duplicating the "Database Mail Profile Name"
CONSQL-1529 Bug Fix: Old security audit data not getting deleted by daily job
CONSQL-1383 Bug Fix: PreChecker UTC threshold should be 30 minutes rather than 20 minutes

Version 3.6.0.8 (2017-10-06) Changes

CONSQL-1504 CONSQL-1505 Feature: Add support for SQL Server for Linux
CONSQL-1584 Improvement: Added dashboard indicator if report mail is not configured
CONSQL-1624 Improvement: Show warning if one or more tables failed when enabling or disabling data sync
CONSQL-1604 Improvement: Added "Backup Type" and "Database File Type" columns to Database Backup Monitoring Email Report
CONSQL-1620 Bug Fix: Should not be able to enable data sync for table that is missing Conductor4SQL system columns
CONSQL-1584 Bug Fix: Daily job should not fail if no mail profile is configured

Version 3.6.0.7 (2017-09-22) Changes

CONSQL-1597 Improvement: We can now audit all ALTER_SERVER events such as enabling and disabling xp_cmdshell
CONSQL-1591 Improvement: Add dashboard indicator and alert email for when Audit Notification Queue is down at client
CONSQL-1590 Improvement: Replace Scheduled User Queries CSV Attachments with embedded html table
CONSQL-1600 Improvement: Move audit alerts email logic to new 'C4SQL Audit Alert' SQL Server Job
CONSQL-1581 Bug Fix: Audit notification queue processor is unstable
CONSQL-1589 Bug Fix: Client Integrated Security not working correctly
CONSQL-1598 Bug Fix: Cannot use wildcards for Audit Alerts
CONSQL-1599 Bug Fix: Cannot use wildcards for Audit Exclusions
CONSQL-1601 Bug Fix: Remove legacy Reporting Services URL config and Reporting Tab

Version 3.6.0.6 (2017-09-08) Changes

CONSQL-1563 Feature: More configurable email notifications
CONSQL-1573 Improvement: Script Editor opens in maximised window state
CONSQL-1622 Bug Fix: Enterprise sync doesn't check for Developer and Evaluation SQL Server editions
CONSQL-1170 Bug Fix: Duplicate Insert on ClientEvent_Types when audit data is populated at central
CONSQL-1580 Bug Fix: Fixed a pulse check issue where pulse checks were not getting sent to all clients if you had more than 500 clients
CONSQL-1583 Bug Fix: Daily job failing on archive step
CONSQL-1588 Bug Fix: Could no longer "View SQL" for queries in Client Console >> Client Control
Numerous PowerBI Report improvements and bug fixes

Version 3.6.0.5 (2017-08-29) Changes

Added PowerBI Report: "Database History Dashboard"
Numerous PowerBI Report improvements and bug fixes

Version 3.6.0.4 (2017-08-03) Changes

Added PowerBI Report: "Jobs Analysis Dashboard"
Numerous PowerBI Report improvements and bug fixes

Version 3.6.0.3 (2017-07-24) Changes

Added PowerBI Reports: "Instance Login Security Dashboard" and "Database Security Dashboard"
Numerous PowerBI Report improvements and bug fixes

Version 3.6.0.2 (2017-07-10) Changes

CONSQL-1508 Improvement: Split get schedule sync changes message to individual messages so getting the data sync changes is more memory efficient
CONSQL-1507 Improvement: Add "time to live" when sending checksums to ensure that checksums do not run during business hours
CONSQL-1499 Improvement: Add new screen to Administration >> Reports section to hold Report KPI threshold values
CONSQL-1496 Improvement: Add dashboard indicator and email report if central report queue is down
CONSQL-1494 Improvement: Move user query save to table to a new database schema called C4SqlSavedQuery
CONSQL-1506 Bug Fix: Fix Disaster Recovery to work with data sync mappings
Numerous PowerBI Report improvements and bug fixes

Version 3.5.0.6 (2017-05-15) Changes

CONSQL-1484 Improvement: Move calculate checksums process to its own SQL job for more configurable run times
CONSQL-1485 Improvement: Add "Table Enable Date" and "Data Sync Type" columns to Data Sync Differences email
CONSQL-1481 Improvement: Upgrade DevExpress components to version 16.1.11
CONSQL-1486 Bug Fix: Checksum script needs to exclude columns with unsupported data types
CONSQL-1487 Bug Fix: Delete message in initial sync is always going over the Default Datasync Queue
CONSQL-1483 Bug Fix: Error in pulse check when both Enterprise Sync and Enterprise Scheduled is enabled
CONSQL-1444 Bug Fix: Real-time data sync bug when updating primary key

Version 3.5.0.5 (2017-04-18) Changes

Feature: Initial PowerBI reports

Version 3.5.0.4 (2017-04-07) Changes

CONSQL-1479 Improvement: When recreating the data sync primary keys move C4SqlClientDatabaseName and ClientID to the end of the primary key to improve update and delete performance
Improvement: Change default timeout for all upgrade scripts to be 20 minutes

Version 3.5.0.3 (2017-03-23) Changes

Bug Fix: getting 'C4SQL Scheduled Sync Errors' even when no errors
CONSQL-1447 Bug Fix: Missing Triggers email needs to be renamed to Missing data sync objects
CONSQL-1446 Bug Fix: When disabling scheduled sync previous scheduled sync errors for the table need to be cleared
CONSQL-1459 Bug Fix: Cannot disable scheduled sync if the staging database has been dropped

Version 3.5.0.2 (2017-03-17) Changes

Bug Fix: Added missing data types into scheduled sync
Bug Fix: Error when sending email for 'C4SQL Data Sync Errors' and 'C4SQL Scheduled Sync Errors'

Version 3.5.0.1 (2017-03-16) Changes

CONSQL-1431 Improvement: added new column C4SqlClientDatabaseName to all data sync tables to cater for more data sync strategies
CONSQL-1430 Feature: Added Enterprise Scheduled sync data sync solution to the product
CONSQL-1426 Feature: Added Scheduled sync data sync solution to the product
CONSQL-1404 Improvement: Simplify stored procedures at client for disabling and enabling datasync

Version 3.4.12.2 (2017-02-23) Changes

CONSQL-1429 Bug Fix: Real-Time data sync triggers getting dropped on client upgrade
CONSQL-1409 Improvement: Add 'DataSyncChecksumEnabled' column to screens 'Manage Tables', 'Central Client Overview', 'Datasync Monitoring' and 'Client Data Sync Monitoring' screen
CONSQL-1428 Bug Fix: Central server now installs correctly on Sql Server 2012 Standard
CONSQL-1425 Improvement: All clients/tables have are blacklisted for checksum calculation in initial installation and upgrades
CONSQL-1111 Improvement: out of transaction messages now remain on the queue when the queue goes into error state
CONSQL-1423 Bug Fix: Missing "Queue Name" column on the "C4SQL Data Sync Behind Notification" email report
CONSQL-1414 Improvement: Add email monitoring for tables that have failed getting activated for datasync

Version 3.4.11.1 (2017-02-07) Changes

CONSQL-1417 Bug Fix: Save To Table not working with UniqueIdentifier columns with nulls
CONSQL-1411 Improvement: Add step in daily job that does data sync table checksums
CONSQL-1413 Improvement: Skip tables when enabling data sync that do not exist or do not have primary keys
CONSQL-1416 Bug Fix: read error on 'create certificate' step in bulk client installer
CONSQL-1407 Improvement: Add 'Check Data Consistency' context menu option to client data monitoring screen
CONSQL-1412 Improvement: Add 'Get Enterprise Sync Data' context menu option to client data monitoring screen
CONSQL-1390 Bug Fix: Incorrect error message when attempting to sync a table that doesn't exist
CONSQL-1410 Improvement: Add 'Checksum Matching' column to central datasync monitoring screen, hidden by default
CONSQL-1402 Bug Fix: Cannot select tickbox on Data Sync Config Overview Screen
CONSQL-1395 Get Enterprise Sync changes go down client queue when manually sent from the client control screen
CONSQL-1399 Improvement: Update documentation and splash screen to 2017 details
CONSQL-1405 Improvement: Add a mechanism for easily calculating table rowcounts and checksums so we can accurately calculate data sync inconsistencies
CONSQL-1406 Bug Fix: We no longer populating the 'Sync Progress' column in 'Client Data Sync Monitoring' Screen

Version 3.4.10.2 (2017-01-13) Changes

CONSQL-1372 Improvement: Add report email for when Enterprise Sync get changes fails

Version 3.4.10.1 (2017-01-12) Changes

CONSQL-1323 Improvement: Mark previous system command error is fixed if its a duplicate
CONSQL-1367 Bug Fix: On Central dashboard the "Clients with messages to process at central" should only include clients where the central queue is down
CONSQL-1371 Bug Fix: Enterprise Sync does not update "Central Last Sync Date" at central
CONSQL-1361 Bug Fix: Get EnterpriseSync message needs to not fail when one or more CDC tables have been manually disabled
CONSQL-1364 Improvement: Add "Fix Missing Data Sync Objects" button to the client datasync dashboard
CONSQL-1329 Improvement: When viewing a clients queue messages added column "Sql Text" to view the actual t-sql messages
CONSQL-1342 Feature: Added datasync checksum and auditing mechanism

Version 3.4.9.2 (2017-01-06) Changes

CONSQL-1360 Bug Fix: "Sync Version" column isn't populating when upgrading clients with "Recreate triggers" selected
CONSQL-1356 Bug Fix: Removed a number of Pulse check deadlock issues
CONSQL-1332 Bug Fix: When bulk upgrading clients the "Recreate triggers" check-box is a floating control when the window is in full screen
CONSQL-1357 Improvment: When sorting a grid on a column the scrollbar should move to the top of the grid rather than focusing on the currently selected row
CONSQL-1359 Bug Fix: Save query results to table feature doesn't handle quotes in varchar fields
CONSQL-1358 Improvement: Add column "Sync Version" when enabling Real-Time or Enterprise datasync for a table
CONSQL-1355 Improvement: Removed content of two tables SB_Store_Status and ClientEventNotificationLog in all client Conductor4SQL databases as this information is redundant
CONSQL-1336 Bug Fix: If a central queue is disabled we only get an email if the central queue has more than 10 messages on it
CONSQL-1333 Improvement: Add "Are you sure?" confirmation when sending user commands/queries to all clients
CONSQL-1327 Bug Fix: Counts on client admin transmission queue not focused per client
CONSQL-1338 Improvement: Enterprise Sync Get Changes messages using incorrect lookup table to check for pending messages
CONSQL-1354 Improvement: Added order by logic to the "C4SQL Data Sync Behind" email report
CONSQL-1351 Bug Fix: Currently selected row is lost on Assign Client Data Sync when the screen is refreshed
CONSQL-1344 Bug Fix: Group select control swap button not working correctly with filtered results
CONSQL-1334 Improvement: Add right-click context to Data Sync Log screen with "Open Client" option
CONSQL-1349 Bug Fix: Open Client from a Missing Triggers Dashboard Details window times out if client is unreachable
CONSQL-1325 Bug Fix: Bulk installer "Start" does not grey out when busy
CONSQL-1348 Bug Fix: Cannot delete client groups anymore
CONSQL-1326 Improvement: Bulk client updater to display if recreating triggers
CONSQL-1328 Bug Fix: Can open the same central dashboard detail screen more than once
CONSQL-1347 Bug Fix: Clicking anywhere on Data sync monitoring "Table" column opens the data sync table preview window
CONSQL-1324 Improvement: Changed Conductor4SQL versioning to Major.Minor.Revision.Sprint
CONSQL-1322 Bug Fix: Data Sync Summary screen not showing the correct information
CONSQL-1340 Bug Fix: Save query results to table feature fails when a clients result set has no rows
CONSQL-1339 Bug Fix: Scheduled user queries "Save query to table name" fields not working
CONSQL-1321 Bug Fix: Reverse sync no longer working
CONSQL-1318 Bug Fix: Data sync behind email showing multiple mappings for single client
CONSQL-1317 Bug Fix: Pulse check does not cater for Enterprise Sync job in Success or Retry state
CONSQL-1319 Bug Fix: Data Sync now handles updating columns to null correctly

Version 3.4.8 (2016-11-01) Changes

CONSQL-1315 Bug Fix: Data Sync Table create script incorrect if table has primary and unique key on same column

Version 3.4.7 (2016-10-25) Changes

CONSQL-1311 Bug Fix: When adding new data sync tables we cannot access tables in schemas other than "dbo"
CONSQL-1313 Bug Fix: Allow enterprise sync to be disabled on table even if Enterprise Sync was disabled manually
CONSQL-1292 Improvement: Allow user to optionally recreate real-time sync triggers when upgrading clients
CONSQL-1308 Bug Fix: float and real data type precision loss in real-time sync table updates
CONSQL-1312 Bug Fix: Real-time Sync update batching bug
CONSQL-1291 Bug Fix: Old Data Sync Messages not getting deletedonfiguration
CONSQL-1294 Bug Fix: Pulse check to check if Sql Server Agent is running not working on named instances
CONSQL-1243 Improvement: Adjust data sync messages to be converted to a base64 message to handle invalid xml characters
CONSQL-1303 Bug Fix: Enable data sync message does not return an error if it failed in data sync log
CONSQL-1301 Bug Fix: The Get Enterprise Sync changes message must fail if Sql Server Agent isn't running
CONSQL-1290 Bug Fix: Enterprise Sync producing incorrect change column list
CONSQL-1293 Bug Fix: Get Enterprise Sync changes message check not working on named instances
CONSQL-1296 Bug Fix: "Number Of Client Upgrader Threads" and "Reporting Server Url" options are not updatable in the administation configuration screen
CONSQL-1297 Bug FiX: System query parameter screen selection glitches
CONSQL-1251 Improvement: Change user command and user query text to base64 to handle special characters e.g. char(0)
CONSQL-660 Improvement: Add check for central client queue disabled on central in windows service checks
CONSQL-1096 Bug Fix: Ensure that queue is disabled before trying to remove poison messages from the queue
CONSQL-1288 Bug Fix: User queries and system queries errors have a full stack trace error rather than just the sql error
CONSQL-1278 Bug Fix: The queues down at central dashboard light only looking "Client Queue" and instead of the "Client Queue" and all the data sync queues for the client
CONSQL-1281 Bug Fix: Cannot uninstall central if one or more tabs are open
CONSQL-1282 Improvement: Add sorting and filtering to the group selection screen when sending user queries/commands
CONSQL-1283 Feature: Add "Skip Initial Sync" option for Enterprise Sync and Real-Time sync

Version 3.4.6.0 (2016-09-13) Changes

CONSQL-1277 Improvement: Persist columns and filters for Client Overview screen
CONSQL-1257 Feature: Add "Skip Initial Sync" option for Enterprise Sync and Real-Time sync
CONSQL-1268 Bug Fix: Invalid cast exception when sending pulse check
CONSQL-1271 Bug Fix: Xml Issue in Error Log Details Report
CONSQL-1265 Bug Fix: Cannot sync a table if it has one or more columns with an apostrophe in column name
CONSQL-1178 Feature: Add Option to resend meta data compare
CONSQL-1148 Feature: Added option "Do not email empty result" to scheduled queries
CONSQL-1267 Bug Fix: Sending a user command or query to a single client was instead getting sent to all clients
CONSQL-1269 Bug Fix: User command/query editor is sending selected text in the script rather than the entire script
CONSQL-1262 Bug Fix: Client auditing doesn't handle NVARCHAR characters
CONSQL-1235 Improvement: Upgrade Dev Express controls to version 16.1.5
CONSQL-1261 Improvement: Show client Audit Notification Queue in client dashboard
CONSQL-1171 Improvement: Adjust grid filters to use "Contains" filter
CONSQL-1232 Bug Fix: Focus jumps to attribute list instead of Business Attribute Name when clicking on "Create Business Attribute" button
CONSQL-1254 Improvement: Optimised underlying query for Client Dashboard screen
CONSQL-1144 Feature: Add dashboard light and email report to check if the Conductor4SQL Windows Service is running
CONSQL-1234 Bug Fix: Bulk installer failing when there is an apostrophe in a clients' business attribute value
CONSQL-1258 Bug Fix: Re-generate table definition option looses data sync queue column
CONSQL-1248 Bug Fix: Fix Trigger data sync message going down the "Client Queue" instead of the dedicated data sync queue
CONSQL-1213 Bug Fix: Add Datasync table is including system tables
CONSQL-1253 Feature: Add Service Broker status check to the client behind diagnostic checks
CONSQL-1239 Feature: Added new 'C4SQL Data Sync Behind' report email
CONSQL-1249 Feature: Added new "C4SQL Enterprise Sync Errors" report email
CONSQL-1236 Feature: Add "Disable queue" context menu option to Client Dashboard grid
CONSQL-1238 Bug Fix: Client Admin Queue down is not showing on Client Dashboard grid
CONSQL-1245 Bug Fix "Missing trigger" details not opening Client Data Sync screen when client is already open
CONSQL-1237 Bug Fix: Auto refresh Client Dashboard screen after enabling a queue so the change reflects immediately
CONSQL-1247 Improvements: Scheduler validation and naming convention improvements
CONSQL-1240 Feature: Added every x minutes option to schedules
CONSQL-1207 Bug Fix: Error when two sql query results get processed at the same time and both try and create the table at central
CONSQL-1231 Bug Fix: Fixed glitch in upgrade scripts
CONSQL-1197 Bug Fix: Table does not have backup data error

Version 3.4.5.0 (2016-08-16) Changes

CONSQL-1205 Feature: Allow user to select a specific client group for gathering report data rather than all clients
CONSQL-1227 Bug Fix: Central Table script generation issues
CONSQL-1225 Improvement: Add success email step to C4SQL Daily Job
CONSQL-1221 Feature: Add "Regenerate Table Definitions" option to Manage Data Sync Tables screen
CONSQL-979 Bug Fix: Data sync trigger fails to drop itself if Conductor4SQL database is not accessible
CONSQL-1218 Feature: Added ability to mark all system error messages as user fixed
CONSQL-1220 Bug Fix: When last Enterprise Sync table is removed from a database Enterprise Sync is disabled from the database
CONSQL-1133 Bug Fix: Precision issue when we have a float as part of the primary key
CONSQL-1217 Improvement: Allow adding tables that have Image, Ntext and text columns by just ignoring these columns when syncing
CONSQL-1211 Bug Fix: Central Queue carries on processing all messages even when queue is disabled
CONSQL-1207 Feature: User Query save to table option
CONSQL-1201 Improvement: Enterprise Sync Job Notifications
CONSQL-1198 Improvement: Added missing primary keys to some Central tables
CONSQL-1172 Bug Fix: Bulk client update does not have a close button when completed
CONSQL-1135 Bug Fix: Get Enterprise Sync message from UI is going down the Client Queue
CONSQL-1174 Improvement: Added support user defined data types for sync
CONSQL-1195 Improvement: Changed CM_Central_Queue_Overview_SP to use a more optimal queue message count method
CONSQL-1173 Bug Fix: Missing triggers email not aligned to dashboard
CONSQL-1184 Feature: Allow user to change the messages to process batch size
CONSQL-1191 Bug Fix: Added default description to Meta data fix messages
CONSQL-1202 Bug Fix: Assign Client Data Sync row selection bug
CONSQL-1199 Improvement: Rename "Database" to "Mapping Name" on Data Sync Screens
CONSQL-1140 Improvement: Allow user to disable data sync from client screen
CONSQL-1146 Feature: Added Data Sync Summary screen
CONSQL-1176 Improvement: Open Client Data Sync Monitoring screen from the Missing Triggers screen

Version 3.4.4.0 (2016-07-07) Changes

CONSQL-1105 Feature: Ability to re-send user command/query
CONSQL-1166 Bug Fix: Missing trigger indicator not reflecting all missing triggers
CONSQL-1167 Improvement: Add missing triggers report to hourly email
CONSQL-1150 CONSQL-1153 Bug Fix: various scheduler bugs

Version 3.4.3.0 (2016-06-24) Changes

CONSQL-1116 Feature: Add group filter on Central Client Dashboard
CONSQL-1156 Bug Fix: Enterprise Sync updating column to NULL not handled correctly

Version 3.4.2.0 (2016-06-21) Changes

CONSQL-1124 Improvement: Client dashboard screen performance issues
CONSQL-1151 Bug Fix: Issue saving Central Client Overview selected columns
CONSQL-1113 Feature: Persist users columns on Client Overview Screen
CONSQL-1147 Improvement: Query result email improvement
CONSQL-1136 Improvement: No client should be selected by default in the Assign Sync screen
CONSQL-1139 Improvement: All grid filters are now case incensitive
CONSQL-1141 Bug Fix: Pulse Check Deadlocks at central
CONSQL-1138 Improvement: Improve logic to check for if Enterprise Sync job and SQL agent is running
CONSQL-1137 Bug Fix: Allow Enterprise Sync get changes to handle non-standard table names
CONSQL-1016 Improvement: Enhancements to Job Details Report, Change existing and create history report
CONSQL-1130 Bug Fix: "Central Active" column should be red when any of the client queues for central is down in Central Client overview
CONSQL-1129 Bug Fix: Fix issue where old query results not working after upgrading central from version 3.3.3 and before
CONSQL-1123 Bug Fix: Add client name and sql executed to Event alert email
CONSQL-919 Bug Fix: Email scheduled query results no longer works
CONSQL-1117 Bug Fix: Deadlock on report data queries
CONSQL-1126 Improvement: Move 'Submit and send another script' tickbox to another location for better consistency
CONSQL-1122 CONSQL-1132 Improvement: Enterprise Sync Optimisations

Version 3.4.1.0 (2016-06-03) Changes

CONSQL-1104 Feature: Add "Submit and send another script" tickbox to the user query/command script editor
CONSQL-989 Improvement: Add column for "Auditing Enabled" on Client Overview Screen
CONSQL-1094 Bug Fix: Timeout error when unassigning data sync tables
CONSQL-1101 Bug Fix: Remove poison message dialog should default on 'Client Queue'
CONSQL-1103 Improvement: Resize Send System message window so all options visible without scrolling
CONSQL-1009 Feature: Add Send System Command button to Client Dashboard screen
CONSQL-1091 Bug Fix: Real-Time sync using client database name instead of central database name in SB_Tablecopy
CONSQL-1092 Bug Fix: Client cleanup script not removing Enterprise Sync temp tables
CONSQL-1090 Bug Fix: Enterprise Sync excluded column update issue
CONSQL-1098 Improvement: Optimised initial sync for wide tables
CONSQL-1081 Bug Fix: Enterprise Sync not disabled after last table is disabled for a client
CONSQL-1099 Bug Fix: Getting wrong error message when removing poison messages

Version 3.4.0.0 (2016-04-26) Changes

CONSQL-991 Feature: Added dedicated data sync queues
CONSQL-1040 Bug Fix: Real-Time Sync data sync precision loss on float fields
CONSQL-1069 Improvement: On Client Dashboard add "Last Error Date" to both queue grids
CONSQL-1089 Improvement: Enterprise Sync Optimisations
CONSQL-1087 Improvement: Added new columns "Initial Sync Start Time" and "Initial Sync End Time" to track initial sync
CONSQL-1079 Bug Fix: C4SQL Clients Over 3 Days Behind report email showing 1900-01-01 for some of the store dates
CONSQL-1077 Bug Fix: Enterprise Sync initial sync max degree of paralellism issue
CONSQL-1071 Improvement: Allow bulk delete of data sync tables
CONSQL-1073 Bug Fix: Cannot disable data sync if no data sync mapping is defined
CONSQL-978 Bug Fix: Enterprise Sync does not support data sync mappings
CONSQL-1064 Bug Fix: Adjust report emails to work with dedicated queues
CONSQL-1062 Improvement: Add Refresh button to Data Sync Log screen
CONSQL-1042 Bug Fix: Remove poison message issues
CONSQL-1056 Improvement: Add 'Enable Queue' and 'Remove Top N Poison messages' context menu items to Client Dashboard grids