Hi! I have a data base that only keeps records of the last 6 months. I need to store this records in a QVD so I can keep them even when those records are not in the data base anymore. I guess that I should do an incremental load every day, storing the records for the new day in the qvd but I don't know how to do it.
This is my script and the date that I need to use is in the field "ts_ins":
LIB CONNECT TO 'Microsoft_SQL_Server_D-STORES1256QLEXPRESS';
Dima:
LOAD id,
MissId,
Skid,
Cont_Code,
Destination,
Description,
Quantity,
MissionDatas,
ts_created,
ts_running,
ts_end,
ts_ins as Fecha_Comun,
ts_read,
Date(MonthStart("ts_ins"),'MMM-YY') as Month_Regulador_Dima,
'AUTOMATICO_PTL' as COD_MAQUINA_REG_DIMA;
[Hist_Missions]:
SELECT id,
MissId,
Skid,
"Cont_Code",
Destination,
Description,
Quantity,
MissionDatas,
"ts_created",
"ts_running",
"ts_end",
"ts_ins",
"ts_read"
FROM "db-Strugal".dbo."Hist_Missions"
where Destination = 'B04';
Thank you in advance.
