Great program guys, unfortunately I dont have the kind of cash to buy it atm, but I like it a lot.
Anyway, I found a couple of bugs on my version (2.4.6) when working with MySQL (5.x) and havnt seen a fix in the change-log so I thought Id post what I found.
1. scripting table create. The script seems to skip regular, non-unique indexes. eg:
One of these scripts is from SqlDbx, the other from a different utility. The script generated by SqlDbx is missing the index
CREATE TABLE rollover_history
aKey INT NOT NULL auto_increment,
RolloverID VARCHAR (40) NOT NULL,
DateDone DATETIME NULL,
MonthendDateUsed CHAR (8) NULL,
Note VARCHAR (255) NULL,
PRIMARY KEY (aKey),
CONSTRAINT Rollover_History_IND1 UNIQUE (RolloverID)
CREATE TABLE `rollover_history` (
`aKey` int(11) NOT NULL auto_increment,
`RolloverID` varchar(40) NOT NULL default '',
`DateDone` datetime default NULL,
`MonthendDateUsed` char(8) default NULL,
`Note` varchar(255) default NULL,
PRIMARY KEY (`aKey`),
UNIQUE KEY `Rollover_History_IND1` (`RolloverID`),
KEY `Rollover_History_IND2` (`DateDone`)
2. Im not sure if its a problem on my side, or a bug, but I cannot script or popup (alt+F1) a script for a MySQL Function. Im Not sure about procedures as I dont have any. When I try, I just get a little window with a big red "X" in it.
As for my last post, the version Im using is 3.4.6, not 2.4.6.
Couple of things. It looks to me that you connect through generic ODBC and not MySQL type of connection.
If you do use MySQL connection then you can check "Use SHOW CREATE... for Scripting" option in Servers->MySQL.
Not sure what is the issue with functions. What version of MySQL and MySQL ODBC driver you use?