Procedure code not obtained from database
I've had MySQL Compare for quite a while and I'm very familiar with SQL Compare but have just now started using MySQL Compare with purpose. MySQL Compare is not reading the procedure code from my database and when I attempt to deploy procedures from one database to another, I get an error Running Synchronization Scripts. Deployment scripts consists consist of nothing more than the example below. Am I doing something wrong? MySQL Compare isn't even getting the name of the procedure, not to mention the code.
-- Script generated by MySQL Compare 126.96.36.1995 on 29-Aug-2015 10:30:29 AM SET @[email protected]@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @[email protected]@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @[email protected]@SQL_MODE, SQL_MODE='ALLOW_INVALID_DATES,NO_AUTO_VALUE_ON_ZERO,NO_AUTO_CREATE_USER'; USE `HSC_Backup`; DELIMITER | | DELIMITER ; SET [email protected]_FOREIGN_KEY_CHECKS; SET [email protected]_UNIQUE_CHECKS; SET [email protected]_SQL_MODE;
0 · Share on Twitter