|
Welcome,
Guest
|
See also the existing examples of using the
SqlServer Adapter
Adapter, which may answer your question:
CSV text file import
,
flat file export
,
Import IDENTITY (Auto Increment) fields
,
CSV export divided into several files
TOPIC: SQL Log files too big.
SQL Log files too big. 7 years 2 weeks ago #2242
|
|
Please Log in or Create an account to join the conversation. |
Re:SQL Log files too big. 7 years 2 weeks ago #2243
|
hi niel,
about database transactions flowheater usually import/update data within one big database transaction. you can change this behavior by setting the adapter property "autocommitafter". set this property to -1 (see picture below) tells flowheater to not use database transactions. maybe this makes sense in your case? note: if something goes wrong during the import/update all data up to this point are written. flowheater can’t rollback these changes! i guess you have only to maintain your database. if your recovery model is set to simple it’s enough to make daily full backups. in other case you can run daily (or weekly) jobs to shrink the transaction log automatically. empty table before importing) this option can take a while for big tables. also this option uses a lot of space in the transaction log as well. it’s possible to use the faster truncate table command. to use truncate table instead of delete table (default) you have to set the adapter property "usetruncate" to true (see picture below). about report errors if you use a batch command script (.bat or .cmd) for your daily automated jobs you can here decide whether fhbatch goes wrong. an error occurs if the errorlevel less than zero. in this case you just send the redirected output "error.log" via an smtp command line utility like blat . example batch cmd script @echo off
set fhbatch="c:\program files\flowheater v2\bin\fhbatch.exe"
rem > redirects the output to the file error.log
%fhbatch% import-export.fhd > error.log
if %errorlevel% lss 0 goto error
echo ok
goto end
:error
rem send an email here
:endhope this helps? 
Best wishes Robert Stark Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem. |
|
Please Log in or Create an account to join the conversation.
Best wishes
Robert Stark Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem. |
