tags:

views:

87

answers:

2

Given two sqlite databases A and B, is there a tool that can generate SQL commands that will convert A to B (or vice versa)? This must included insertions, deletions, and updates - and maybe also table alterations (though that's not important to me).

Possibly this tool is not even sqlite-specific.

+2  A: 

Could this be what you are looking for?

SQLite Compare

Not sure what you mean by

Possibly this tool is not even sqlite-specific.

But a Sql Server specific one is available too.

SQL Data Compare

astander
Almost. GUI comparison is nice, but what I wanted is automatic script generation.
noamtm
A: 

So,

This tool proposes this: http://www.fmpromigrator.com/products/sqlite_diff/index.html

Ricardo