1. Connection to SQL Server via ODBC and SQL Log Housekeeping 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 do... Read More
2. Suspend SQL Mirroring During Night / Weekends 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
3. 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 ... Read More
4. Datafile SQL Monitor 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 memor... Read More
5. Running the SQL Manager 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
6. Configuring the Datafile System 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 ent... Read More
7. SQL In 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 Usernam... Read More
8. SQL Out 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
9. Datafile SQL Configuration 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 c... Read More
10. Installing the Datafile SQL Driver 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 &l... Read More