CONSOLE

Option overrides

The -OPT switch changes project options for one run without editing the project:

FullConvertConsole.exe project.fcpx -OPT "WorkerLimit=4;Timeout=600;DataCopying=Delta"

Separate several options with semicolons. Booleans are true or false, choices use the names listed here, text and numbers are given as they are. Options that are not overridden keep the value saved in the project.

SectionOptionValues
ConversionTableCreationRecreate, ExpectExisting
DataCopyingEverything, Delta (added records), Append, None
CreateIndexestrue, false
CreateForeignKeystrue, false
UseSelfReferencingUpdatestrue, false
Incrementingtrue, false
DefaultValuestrue, false
NullabilityDefault, Null, NotNull
ComparisonIgnoreFractionalSecondstrue, false
EmptyStringsSameAsNullstrue, false
IgnoreNullCharactertrue, false
TempDataFolderfolder path
DetectInsertstrue, false
DetectUpdatestrue, false
DetectDeletestrue, false
PerformanceNeverCountRecordstrue, false
FetchMetaOnlyForSelectedTablestrue, false
WorkerLimit1 to 64
DatabaseTablePrefixtext
CasingDefault, Uppercase, Lowercase, Unchanged, CamelCase, PascalCase, SnakeCase, ScreamingSnake
SourceWhereSQL condition
TargetWhereSQL condition
LoggingLogStrategyNoLogging, Overwrite, TimestampedFolder, TimestampedFiles, Append
SummaryLog, ErrorLog, WarningLog, SqlLog, ErrorSqlLog, JsonLogfile path
Custom scriptsRunSqlOnEachConnectiontrue, false
BeforeScriptSource, BeforeScriptTarget, AfterScriptSource, AfterScriptTargetSQL file path
BeforeSystemCommand, AfterSystemCommandprogram or batch file path
NotificationEmailBehaviorNever, Always, OnError
EmailTo, EmailFrom, EmailSmtpServer, EmailUsername, EmailPasswordtext
EmailSmtpPortport number
EmailSsltrue, false
TroubleshootingTimeoutseconds, 0 for none
SingleInsertstrue, false
Previous
Usage
Next
Connection overrides

If this was useful,
our newsletter will be too.

Get monthly insights on data engineering, AI, and building critical infrastructure - direct from the Spectral Core team and CEO Damir Bulic.