discrepancies in database exports

I use the "Export Database as SQL" feature a lot to get my databases into a sql file and then use a file compare file like WinMerge to compare 2 databases to I can find exactly what got changed when going from Test to Prod, etc. Well often times there will be weird discrepancies between two database sql files.

Here is an example: DB1: CREATE PROCEDURE copyQuoteRulesWithNewQuoteID( DB2: CREATE PROCEDURE "copyQuoteRulesWithNewQuoteID"(

See the difference is the quotes. I don't understand why one export would use double quotes and one would use back ticks. It is very sporadic. I'm not changing any settings between the two exports.

Here is another discrepancy that is difficult to fix: DB1: KEY idx_plq_quote_price (quoteID,priceListID), DB2: KEY idx_plq_quote_price (quoteID,priceListID) USING BTREE,

Again, I have no idea why one export is printing "USING BTREE" and one isn't. No settings changes between the two.

Any ideas on how I can get duplicate exports would be great!

The forum formatter appears to have stripped out my back ticks. But there were backticks for the DB1 example around "copyQuoteRulesWithNewQuoteID"

I'll try adding spaces... copyQuoteRulesWithNewQuoteID

Trying this again, separating out the examples correctly on separate lines to avoid confusion. The first one I replaced the backticks with single quotes, but it was actually backticks in the export.

DB1: CREATE PROCEDURE 'copyQuoteRulesWithNewQuoteID'(

DB2: CREATE PROCEDURE "copyQuoteRulesWithNewQuoteID"(

DB1: KEY idx_plq_quote_price (quoteID,priceListID),

DB2: KEY idx_plq_quote_price (quoteID,priceListID) USING BTREE,

Which server versions are your prod and test environment?

As you're already working with WinMerge, I would dump the both servers system variables (SHOW variables;) into a csv file and compare them with WinMerge. These may also affect the export file.