Home » Categories » Solutions by Business Process » SQL |
Database Refresh - Empty Table and Re-Import Data |
Article Number: 109 | Rating: Unrated | Last Updated: Mon, Jun 12, 2023 at 2:46 PM
|
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
Database you can set flag options as to whether a database is to be mirrored as
an SQL table or not, and set which items are to be mirrored (if left blank all
items are mirrored). New in Release 6.4
is an option to set whether a refresh of the database triggers a drop and
recreation of the SQL table (as now) or an empty and import of the data into
the SQL table. Mirror this database in SQL – set to Y to mirror the database in SQL (Note: if SQLDET.DFD not found in DFCOMP location system will warn accordingly) Auto Refresh Whole Structure of Just Contact – set to R to drop/recreate table on refresh, set to F to empty/import data. If left blank system assumes a refresh drop/recreate SQL table. Note Drop/Recreate of the SQL table is generally avoided where you will be linking your own SQL tables to a Datafile mirrored table rather than reporting from the mirrored table. If you restructure the database, however, then the system does still drop/recreate the table so that the SQL mirror matches the Datafile structure. |
Attachments
![]() There are no attachments for this article.
|
Installing the Datafile SQL Driver
Viewed 3446 times since Thu, Jul 5, 2012
SQLDET Database Structure
Viewed 5031 times since Mon, Jun 11, 2012
Running the SQL Manager
Viewed 2893 times since Thu, Jul 5, 2012
Additional SQLDET.DFD Maintenance Options
Viewed 11373 times since Mon, Jun 11, 2012
SQL Out
Viewed 2765 times since Thu, Jul 5, 2012
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 5385 times since Fri, Jul 21, 2017
Datafile SQL Configuration
Viewed 2530 times since Thu, Jul 5, 2012
Suspend SQL Mirroring During Night / Weekends
Viewed 2591 times since Fri, Oct 26, 2012
Datafile SQL Driver
Viewed 2968 times since Thu, Jul 5, 2012
Configuring the Datafile System
Viewed 2866 times since Thu, Jul 5, 2012
|