Comments
Sort by recent activity
Not sure if people would really be bothered to use those hints in comments. Wouldn't it be better if we added a feature that scanned all the objects you used your stored procedure and moved thouse to the top of the list in a most recently used section?
Lionel / comments
Not sure if people would really be bothered to use those hints in comments. Wouldn't it be better if we added a feature that scanned all the objects you used your stored procedure and moved thouse ...
The END and the HOME keys should jump you to the top and the bottom list.
Lionel / comments
The END and the HOME keys should jump you to the top and the bottom list.
Lionel
I have added an option to remove the tablename.column entries as this seems like a better way to solve this particular problem.
Lionel / comments
I have added an option to remove the tablename.column entries as this seems like a better way to solve this particular problem.
Lionel
Hi
I am really sorry you have had problems. At the moment the DDL changes are not wrapped an a transaction but my understanding and experiments indicate that DDL operations are not transactional. In fact, if you run a DDL statement it seems to commit the current transaction. This is using InnoDB on version 5.1.45 (I haven't tried it on other storage engines/versions). If I am wrong please let me know!
If you know what caused the synchronization to fail please let me know and I will try and fix the bug!
Lionel / comments
Hi
I am really sorry you have had problems. At the moment the DDL changes are not wrapped an a transaction but my understanding and experiments indicate that DDL operations are not transactional. I...
Btw way I am very sorry it took me so long to reply to your post!
Lionel / comments
Btw way I am very sorry it took me so long to reply to your post!
Lionel
Thanks a lot for the feedback. You're correct that those statements should definitely be amalgamated together. Sorry, I didn't read the docs for the alter statement carefully enough so I didn't realise you could do that. I will fix that and hopefully put it in the new EAP.
Lionel / comments
Thanks a lot for the feedback. You're correct that those statements should definitely be amalgamated together. Sorry, I didn't read the docs for the alter statement carefully enough so I didn't rea...
Hi
Thanks for all the great feedback. Glad you are finding the program useful and since it is only the first EAP I am sure I will have lots of time to remove the niggles [image] .
I will have a look at the zero value datetime default issue. It sounds like I need to add some code to treat the zero values differently. Definitely sounds like and oversight on my part sorry.
I was having great difficulty in getting the database versions directly from the server as the strings returned by the server have wildly different formats. That information will definitely get improved. MySQL Compare should support MySQL version 5.0 as well as version 5.1, however there are some problems with the v5 support. Hence sticking to 5.1 is better at the moment.
The wobbling problem sounds really bizarre - I will look into it shortly.
Regarding having the storing the credentials on the project page - this screen is going have an overhaul shortly as I would like to add other ways of connecting to the database. Whilst doing this I try and find a way of incorporating your suggestions into the design.
In respect to the two Finds - we also hit this problem while building SQL Compare and never really agreed on a good compromise. Your suggestions will be taken on board and I'll see if we can hammer out something better.
You also mentioned the erroneous differences in the sync scripts. I will remove the database names from the script, as they are not necessary. I'll have a look at the highlighting of the incremented values too.
Finally, I have actually fixed the bug with the resizing columns, but it didn't quite make it into the EAP.
Glad you are enjoying MySQL Compare and thanks for all your detailed feedback.
Lionel / comments
Hi
Thanks for all the great feedback. Glad you are finding the program useful and since it is only the first EAP I am sure I will have lots of time to remove the niggles .
I will have a look at the...
Hi
Unfortunately there is no way setting the connection timeout at the moment. If you enable verbose logging (which you can do by clicking the icon in the top left hand corner of the window and using the menu item to set the log level) and then try and connect to the database again the error should get added to the log. If you could post the exception I will try and track it down and get you a fixed version. I am afraid you might have to wait until next week til I can get you a fix as I am on holiday at the moment.
Lionel / comments
Hi
Unfortunately there is no way setting the connection timeout at the moment. If you enable verbose logging (which you can do by clicking the icon in the top left hand corner of the window and usi...
Hi
MySQL Compare uses the INFORMATION_SCHEMA tables to get the schema information about the two databases in the comparison. Since the information_schema tables hold information about all the databases on the server I suspect that MySQL is trying to load the information about the corupt databases even though I am filtering out that information. Not sure how much I will be able to do about fixing the slow registration problem as it is sounds like a MySQL issue. I will try and see if I can track the problem down and think of a way round the it.
Lionel / comments
Hi
MySQL Compare uses the INFORMATION_SCHEMA tables to get the schema information about the two databases in the comparison. Since the information_schema tables hold information about all the datab...
That sounds like a great sugestion! I will look at getting some form of ssh tunneling into the product. Are there any other ways of connecting you think we need to support?
Lionel / comments
That sounds like a great sugestion! I will look at getting some form of ssh tunneling into the product. Are there any other ways of connecting you think we need to support?
Lionel