Category Articles RSS Feed
Additional SQLDET.DFD Maintenance Options
Viewed 8934 times since Mon, Jun 11, 2012
Datafile Software Additional SQLDET.DFD Maintenance Options Various maintenance options have been added to the system for the SQLDET.DFD (this is the ‘log’ file of changes to Datafile databases set to be mirrored). List SQLDET... Read More
SQLDET Database Structure
Viewed 4309 times since Mon, Jun 11, 2012
Datafile Software SQLDET Database Structure Two new data items can be added to the SQLDET.DFD file that will record the program and the parameter number which generated, together with the existing (Premier only) options to record the user-id,... Read More
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 4208 times since Fri, Jul 21, 2017
SQL Replicator Connection to SQL Server via ODBC   The Datafile SQL Replicator connects directly to a MySQL or MsSQL Server.  Where the server is on a remote connection you may want to use SSL.   The existing connection options... Read More
Update Individual Records to SQL on Nominal Update
Viewed 2638 times since Fri, Oct 26, 2012
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... Read More
Installing the Datafile SQL Driver
Viewed 2601 times since Thu, Jul 5, 2012
Datafile Software Installing the Datafile SQL Driver The Datafile SQL Driver is supplied either within a folder on a standard installation CD, or as a Web Download in its own right. If supplied with a standard installation CD then a folder ... Read More
Database Refresh - Empty Table and Re-Import Data
Viewed 2284 times since Mon, Jun 11, 2012
Datafile Software Database Refresh - Empty Table and Re-Import Data Release 6.4 introduces several additional processing options for mirroring a Datafile Database to an SQL table when the SQL Driver has been purchased.  Against each Datafile... Read More
Datafile SQL Driver
Viewed 2249 times since Thu, Jul 5, 2012
Datafile Software Datafile SQL Driver The Datafile Database is a proprietary database – this means that the data within can be read and updated within the Datafile Software suite of programs but not by other programs. To access the data with... Read More
Running the SQL Manager
Viewed 2226 times since Thu, Jul 5, 2012
Datafile Software Running the SQL Manager Once you have databases set to mirror / import you are ready to run the SQL Manager – run this from the desktop and/or the menu on start-up menu. When run a small ‘grey’ form will display... Read More
Datafile SQL Monitor
Viewed 2099 times since Thu, Jul 5, 2012
Datafile Software Datafile SQL Monitor The Datafile SQL Monitor oversees the SQLMgr program checking for memory usage and time responses. The monitor checks on a set time period (configurable) and if a condition is triggered such as high... Read More
SQL Out
Viewed 2081 times since Thu, Jul 5, 2012
Datafile Software SQL Out The SQL Configuration has two schedules – one for SQL updates TO the Datafile system, and one for SQL Updates FROM the Datafile System. (SQL Updates to the Datafile system are outside the purview of this manual.) To... Read More
Configuring the Datafile System
Viewed 2066 times since Thu, Jul 5, 2012
Datafile Software Configuring the Datafile System Adding the DFSQL User In operation the Datafile SQL Driver accesses the Datafile System with a DFSQL user-id and this user-id needs to be added to the list of user-ids within Datafile as... Read More
SQL In
Viewed 1967 times since Thu, Jul 5, 2012
Datafile Software SQL In The SQL In parameters ask: Optimise Records – this asks the number of entries processed in one loop. IP Address – enter the IP Address of the SQL server Database – enter the database name on the SQL server... Read More
Suspend SQL Mirroring During Night / Weekends
Viewed 1922 times since Fri, Oct 26, 2012
Datafile Software Suspend SQL Mirroring During Night / Weekends The SQLMGR program, once started, reads the SQLDET database continually for new records to process and can mean – when your business operates on a set opening times basis – that... Read More
Datafile SQL Configuration
Viewed 1875 times since Thu, Jul 5, 2012
Datafile Software Datafile SQL Configuration Running the SQL Configuration option allows you to configure the link from the Datafile system to the SQL Database. It is important to note at this point that SQL is not a layman’s tool. The... Read More