|
<< Click to Display Table of Contents >> Navigation: Programming Mechworks PDM > DBWCommandShell > Commands Reference > Database > BackupDatabaseRange |
available from build: 20050420 |
It allows to export a large data set.
It has to be used together with the Briefcase technology in it's modality for zipping/unzipping files only.
call DBWShell("BackupDatabaseRange BackupFilePath uidMin uidMax SQLfilter")
BackupFilePath |
the written backup file |
|---|---|
uidMin |
the minimum UNIQUE_ID value allowed for the local company |
uidMax |
the maximum UNIQUE_ID value allowed for the local company |
SQLfilter |
an SQL expression for filtering records to backup, based on specific attributes |
Disconnected Database Replication Model
sub main()
DBWInit(TRUE)
backupFilePath = replace("C:\FromMechWorksToExtern1.BKP"," ","|")
' MechWorks COMPANY unique id range
uidMin = 100000000
uidMax = 200000000
backupFilter = replace("T IN ('0','A','P') AND CATEGORY1 LIKE '%norm%'"," ","|")
DBWShell("BackupDatabaseRange " & backupFilePath & " " & uidMin & " " & uidMax & " " & backupFilter )
end sub