Which Tool to use for generating a Schema Diff?

[sdevaiah]

Are there any tools recommended to produce a good schema diff between two MemSQL schemas? For example, I have an older version of a memsql schema and a newer version of a memsql schema, and I’d like to have the diff generate DDL which will ‘upgrade’ the schema on old to match the schema on new with the necessary adds/drops/alters/etc.

[prerak]

Any tool that can help compare 2 memsql database schemas and create the migration script

I posted this in the other thread too, but thought will post it here and it may help someone. The below tool not only finds all of the differences but produces the exact ALTER / CREATE syntax that is used by Singlestore, including the sharding, indexes, table types. The best tool I found for this, believe it or not, is the perl mysqldiff utility (part of MySQL::Diff module). This is not to be confused with a similarly named MySQL utility. I couldn’t really find anything else that does a good jo…

[ezraalipv68]

Several comments have been deleted. All were relevant. Why the deletions?

[tariqsohaib51]

your good information and interesting question but i am not idea.

[wfaulkner]

Do you recall which comments you saw were deleted? Were those comments yours? I want to look into this to see what I can find.