<?xml version="1.0"?>

<rss version="2.0">


<channel>
<title>Home - All Categories - Solutions by Business Process  - SQL  </title>
<link>https://kb.datafile.co.uk/category/solutions-by-business-process/sql/</link>
<description>This RSS Feed contains Articles of Category in the knowledge base. You can click on the title to view its content.</description>
<item>
										<guid>https://kb.datafile.co.uk/article/additional-sqldetdfd-maintenance-options-111.html</guid>
										<title>Additional SQLDET.DFD Maintenance Options</title>
										<link>https://kb.datafile.co.uk/article/additional-sqldetdfd-maintenance-options-111.html</link>
										<description><![CDATA[Datafile Software    Additional SQLDET.DFD Maintenance Options   Various maintenance options have been added to the system for the SQLDET.DFD (this is the &lsquo;log&rsquo; file of changes to Datafile databases set to be mirrored).       List SQLDET...]]></description>

									</item>
<item>
										<guid>https://kb.datafile.co.uk/article/connection-to-sql-server-via-odbc-and-sql-log-housekeeping-2205.html</guid>
										<title>Connection to SQL Server via ODBC and SQL Log Housekeeping</title>
										<link>https://kb.datafile.co.uk/article/connection-to-sql-server-via-odbc-and-sql-log-housekeeping-2205.html</link>
										<description><![CDATA[SQL Replicator Connection to SQL Server via ODBC &nbsp; The Datafile SQL Replicator connects directly to a MySQL or MsSQL Server.&nbsp; Where the server is on a remote connection you may want to use SSL.&nbsp;&nbsp; The existing connection options...]]></description>

									</item>
<item>
										<guid>https://kb.datafile.co.uk/article/sqldet-database-structure-110.html</guid>
										<title>SQLDET Database Structure</title>
										<link>https://kb.datafile.co.uk/article/sqldet-database-structure-110.html</link>
										<description><![CDATA[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,...]]></description>

									</item>
<item>
										<guid>https://kb.datafile.co.uk/article/installing-the-datafile-sql-driver-1719.html</guid>
										<title>Installing the Datafile SQL Driver</title>
										<link>https://kb.datafile.co.uk/article/installing-the-datafile-sql-driver-1719.html</link>
										<description><![CDATA[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 ...]]></description>

									</item>
<item>
										<guid>https://kb.datafile.co.uk/article/update-individual-records-to-sql-on-nominal-update-1934.html</guid>
										<title>Update Individual Records to SQL on Nominal Update</title>
										<link>https://kb.datafile.co.uk/article/update-individual-records-to-sql-on-nominal-update-1934.html</link>
										<description><![CDATA[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...]]></description>

									</item>
<item>
										<guid>https://kb.datafile.co.uk/article/database-refresh-empty-table-and-re-import-data-109.html</guid>
										<title>Database Refresh - Empty Table and Re-Import Data</title>
										<link>https://kb.datafile.co.uk/article/database-refresh-empty-table-and-re-import-data-109.html</link>
										<description><![CDATA[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. &nbsp;Against each Datafile...]]></description>

									</item>
<item>
										<guid>https://kb.datafile.co.uk/article/configuring-the-datafile-system-1723.html</guid>
										<title>Configuring the Datafile System</title>
										<link>https://kb.datafile.co.uk/article/configuring-the-datafile-system-1723.html</link>
										<description><![CDATA[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...]]></description>

									</item>
<item>
										<guid>https://kb.datafile.co.uk/article/datafile-sql-driver-1718.html</guid>
										<title>Datafile SQL Driver</title>
										<link>https://kb.datafile.co.uk/article/datafile-sql-driver-1718.html</link>
										<description><![CDATA[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...]]></description>

									</item>
<item>
										<guid>https://kb.datafile.co.uk/article/running-the-sql-manager-1724.html</guid>
										<title>Running the SQL Manager</title>
										<link>https://kb.datafile.co.uk/article/running-the-sql-manager-1724.html</link>
										<description><![CDATA[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 &lsquo;grey&rsquo; form will display...]]></description>

									</item>
<item>
										<guid>https://kb.datafile.co.uk/article/datafile-sql-monitor-1725.html</guid>
										<title>Datafile SQL Monitor</title>
										<link>https://kb.datafile.co.uk/article/datafile-sql-monitor-1725.html</link>
										<description><![CDATA[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...]]></description>

									</item>
<item>
										<guid>https://kb.datafile.co.uk/article/sql-out-1721.html</guid>
										<title>SQL Out</title>
										<link>https://kb.datafile.co.uk/article/sql-out-1721.html</link>
										<description><![CDATA[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...]]></description>

									</item>
<item>
										<guid>https://kb.datafile.co.uk/article/suspend-sql-mirroring-during-night-weekends-1935.html</guid>
										<title>Suspend SQL Mirroring During Night / Weekends</title>
										<link>https://kb.datafile.co.uk/article/suspend-sql-mirroring-during-night-weekends-1935.html</link>
										<description><![CDATA[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...]]></description>

									</item>
<item>
										<guid>https://kb.datafile.co.uk/article/sql-in-1722.html</guid>
										<title>SQL In</title>
										<link>https://kb.datafile.co.uk/article/sql-in-1722.html</link>
										<description><![CDATA[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...]]></description>

									</item>
<item>
										<guid>https://kb.datafile.co.uk/article/datafile-sql-configuration-1720.html</guid>
										<title>Datafile SQL Configuration</title>
										<link>https://kb.datafile.co.uk/article/datafile-sql-configuration-1720.html</link>
										<description><![CDATA[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&rsquo;s tool. The...]]></description>

									</item>

</channel>

</rss>