Feature Request – View Database Sync Sql

[peterlaursen]

I think the problem is that the is no 'total SQL file' for a DATA sync job. When the tool starts at one end it does not 'know' what comes after. To implement your request we would need to enable a 'simulation mode', where it does not execute commands, but writes to a file instead.

I don't know how useful it is. It is individual INSERTS, UPDATES and DELETES for each row where an operation needs to be performed. It may be thousands of individual statements. And I do not know either how (human) readable it will be. It is the WHERE clause that is the problem. Probably Ritesh can be more specific.

Do you think that you can use that information? I'd rather say it is better to backup data before sync'ing. You can run a backup and a sync as a single batch job.

But let us hear Ritesh …

[Ritesh]

I am not sure how logging of queries that will bring changes to the DB would be helpful but we did have lot of request for the same.

Basically, instead of executing the INSERT/UPDATE statement, we log it into the file. This is not very hard to implement and we do plan to implement this feature soon.

[Author]

Posts