Comments
Sort by recent activity
Hi guys,
Thanks for pointing out this issue. I've made a fix and uploaded it here: http://downloads.red-gate.com/checkforu ... .0.160.exe
Please give that a go and let me know if it fixes the SQL 2000 problem.
Happy New Year!
Neil / comments
Hi guys,
Thanks for pointing out this issue. I've made a fix and uploaded it here:http://downloads.red-gate.com/checkforu ... .0.160.exe
Please give that a go and let me know if it fixes the SQL 20...
Hi integragroup,
v10 of SQL Compare allows you to create a new database straight from the edit project dialog. Compare checks if the database specified in the database name field exists and if not it presents you with the option to create one.
It seems in your case Compare is acting strangely. If you picked the db names from the dropdown then they exist, so you shouldn't get the "Create Database" screen when you hit compare now.
Can you give me some more detail about the error? What version of SQL Server are your remote dbs on? What are the database names? Is there anything special/different about them? Does this happen all the time for you?
Thanks,
Neil / comments
Hi integragroup,
v10 of SQL Compare allows you to create a new database straight from the edit project dialog. Compare checks if the database specified in the database name field exists and if not ...
Hi JamesC2,
Thanks for getting back to me. Can you please tell me what version of MySQL you are using? On version 5.1.53 with your example Compare picks up the difference in the onupdate field and produces the script below. -- Script generated by MySQL Compare 1.0.0.292 on 22/12/2011 13:16:26
SET @ORIGINAL_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @ORIGINAL_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @ORIGINAL_SQL_MODE=@@SQL_MODE, SQL_MODE='ALLOW_INVALID_DATES,NO_AUTO_VALUE_ON_ZERO,NO_AUTO_CREATE_USER';
USE `dummy2`;
ALTER TABLE `tablename1`
MODIFY COLUMN `onupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP;
SET FOREIGN_KEY_CHECKS=@ORIGINAL_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@ORIGINAL_UNIQUE_CHECKS;
SET SQL_MODE=@ORIGINAL_SQL_MODE;
Which I believe is what you would expect? / comments
Hi JamesC2,
Thanks for getting back to me. Can you please tell me what version of MySQL you are using? On version 5.1.53 with your example Compare picks up the difference in the onupdate field and ...
Hi JamesC2,
Thanks for your detailed bug report. I'm happy to be able to tell you that this has been fixed in the latest version of the MySQL tools. If you Check for Updates from the Help menu you will receive the latest or alternatively you can download it from the www.mysqlcompare.com website.
I'm glad you are enjoying using the tools. Please let us know if you find that this bug is not actually fixed.
We really want to make sure the MySQL tools are of the highest quality so feedback such as this is very important to us. Thanks for your time.
Neil / comments
Hi JamesC2,
Thanks for your detailed bug report. I'm happy to be able to tell you that this has been fixed in the latest version of the MySQL tools. If you Check for Updates from the Help menu you ...
Hi Chris,
Thanks for telling us about this bug. We believe we have fixed it and it is available for you here: http://downloads.red-gate.com/checkforu ... .0.143.exe
Please give that a go and let me know if the bug still persists.
Thanks,
Neil / comments
Hi Chris,
Thanks for telling us about this bug. We believe we have fixed it and it is available for you here:http://downloads.red-gate.com/checkforu ... .0.143.exe
Please give that a go and let me ...
Hi va2dos,
I've contacted you via email to get some more info.
Thanks,
Neil / comments
Hi va2dos,
I've contacted you via email to get some more info.
Thanks,
Neil
Hi Steve,
Thanks for trying out the tool.
It looks like a bug to me. I would hazard a guess that when we do a rebuild and create a temp table the constraint names are not unique because we obtained them from the table we are rebuilding so MySQL is complaining. I'll look into that and get back to you asap.
I'll also try and find you an answer as to why we do a rebuild here instead of an alter.
Neil / comments
Hi Steve,
Thanks for trying out the tool.
It looks like a bug to me. I would hazard a guess that when we do a rebuild and create a temp table the constraint names are not unique because we obtained...
Hi wfranklin,
I've sent you a link to the latest build. Please let me know if this has fixed the bug.
Thanks,
Neil / comments
Hi wfranklin,
I've sent you a link to the latest build. Please let me know if this has fixed the bug.
Thanks,
Neil
Hi smacferson,
I have emailed you for some more information.
Thanks,
Neil / comments
Hi smacferson,
I have emailed you for some more information.
Thanks,
Neil
Hi bbabic,
You're right. This bug was reported quite a while ago and has not yet been fixed. Myself and a few of the other devs here built the MySQL tools in our Down Tools time http://www.youtube.com/watch?v=nitqtm_ILG8 and as a result there have been long spells where we have either been working on the MySQL Data Compare tool or the SQL Server tools and this bug slipped through the cracks.
In our latest Down Tools week we addressed the main features that our users requested after Lionel's initial EAP last year. They included SSH support, ignoring AUTO INCREMENT and others. Now that those are done we would like to focus on the remaining bugs reported with the latest EAP. This is one of those. We've had one other report of this occuring with the latest build and as yet have been unable to reproduce it.
I appreciate from your last post that you may have given up on this bug but if you are still willing it would be of great help to us if you could turn on verbose logging, reproduce the problem and send the logs to MySQL@red-gate.com. Anything else about the schema (such as SHOW CREATE TABLE outputs) that you can include would also be great.
Thanks,
Neil / comments
Hi bbabic,
You're right. This bug was reported quite a while ago and has not yet been fixed. Myself and a few of the other devs here built the MySQL tools in our Down Tools time http://www.youtube....