Command Line Sync Delete issue

[SouldrinK]

When syncing via command line and adding /sync - is there a way to make it only use update/insert commands? If target adds a new record, I don't want it deleted in the sync, I'd rather it actually sync and add it to the source. (There is no deleting in the two databases via the application that's using them)

I searched forums and the help files, nada.

Please educate me or let me know I should not purchase beyond the trial date. Thanks!

[alexa]

This can be done as follows:

1. Start the GUI of the product.
2. Invoke the Data Comparison wizard.
3. On the 'Options' page of the Data Comparison wizard, unselect the 'Only in target records' option.
4. Once the data comparison document is generated, save it to the *.dcomp file.

The saved *.dcomp can be now used in the command line interface and should solve your task.

Please let us know if that's what you need.

[SouldrinK]

That's not quite what I was looking for. I was hoping for a method to synchronize two databases that both have modifications to tables, without deleting entries from either side. It's a mobile office management application that has patient records that will be added/edited by multiple sources, but not all computers are online so an offline database is used. I was hoping a command line script using your software could sync the changes (as I said before there are no deleted, but simply marking the record/patient "inactive" since they are records)

localdatabase -> remotedatabase adding/updating all new rows
remotedatabase -> localdatabase adding/updating all new rows

Is there a solution to this?

Thanks!

[alexa]

Could you please clarify what you mean by 'offline database' ?