Home » Categories » Solutions by Business Process » SQL

Update Individual Records to SQL on Nominal Update

Datafile Software

Update Individual Records to SQL on Nominal Update

When updating from sales/purchase ledgers to nominal ledger then if any databases involved are set to mirror to a SQL database then the system will generate a refresh of these databases (SLT / PLT / NLT / NLA) rather than update individual records as this tends to update the mirrored tables more quickly.

Where large databases are in use and updates are run frequently (daily rather than at period end) then a global refresh of the data may take longer than an individual record update may take.A new option has been added within the Nominal Updating definition to allow the facility to mirror individual record changes.


Omit SQL File Refresh – if set then the system omits the full table refresh of the import/output databases within the Nominal update and instead updates the mirrored table through individual record updates.

Multiple File Updating

If using the multiple updating definition file this parameter is available via the ‘General Details / Which Systems Allowed’ parameter screen.

Custom Fields
  • Release ID: 6.6
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Running the SQL Manager
Viewed 2372 times since Thu, Jul 5, 2012
Suspend SQL Mirroring During Night / Weekends
Viewed 2047 times since Fri, Oct 26, 2012
Datafile SQL Monitor
Viewed 2234 times since Thu, Jul 5, 2012
Datafile SQL Configuration
Viewed 1998 times since Thu, Jul 5, 2012
Configuring the Datafile System
Viewed 2225 times since Thu, Jul 5, 2012
Database Refresh - Empty Table and Re-Import Data
Viewed 2389 times since Mon, Jun 11, 2012
Additional SQLDET.DFD Maintenance Options
Viewed 9978 times since Mon, Jun 11, 2012
SQLDET Database Structure
Viewed 4461 times since Mon, Jun 11, 2012
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 4390 times since Fri, Jul 21, 2017
SQL In
Viewed 2089 times since Thu, Jul 5, 2012