Forums » General Discussion

Thread: Schema Compare - and website problem


Permlink Replies: 4 - Pages: 1 - Last Post: Jun 29, 2010 2:46 PM by: jlffool
Yehuda Katz
Schema Compare - and website problem
Posted: Mar 5, 2010 6:26 AM
  Click to reply to this thread Reply

What is the most recent version of Toad MySQL (betas included) where the schema compare worked?This is the feature I use most and to see that it does not work in the recent betas is rather discouraging. 

Also, on the forums, when I try to set my watch list preferences I get a tomcat error.I tried reporting it using the link at the bottom of the page: Report a Problem with This SiteThe message bounces back with: 550 No such user<!--~-|**|PrettyHtmlStart|**|-~-->


Dwight


Posts: 68
Registered: 8/22/07
Re: Schema Compare - and website problem
Posted: Mar 9, 2010 11:55 AM   in response to: Yehuda Katz
  Click to reply to this thread Reply

Yehud,

What kind of trouble are you having with Schema Compare. Can you describe what is happening?

I will double-check the watch-list code and see if we can fix the issue.


Dwight


bart.baeyens@cronos.be


Posts: 2
Registered: 12/14/06
Re: Schema Compare - and website problem
Posted: Apr 29, 2010 12:26 AM   in response to: Dwight
  Click to reply to this thread Reply

I am using version 4.6.0.531 and have also difficulties using schema compare, the utility i'd like to use the most.

I get an error 'SELECT command denied to user 'A212@....fro table 'db'
Quest.Compare.Schema.MySQL.DBModel'

(using MySQL Workbench with the same users/databases does not give any problem, except that I find the output of that compare tool rather messy)

I do not have this error when trying to execute a Data Compare, that works (and even gives me a sort of view on the existing difference between the schemata)

Thx for helping me out.




LCDServices

Posts: 1
Registered: 5/27/10
Re: Schema Compare - and website problem
Posted: Jun 21, 2010 6:59 AM   in response to: bart.baeyens@cr...
  Click to reply to this thread Reply

I'll chime in as well --
Running 4.6.x stable and schema compare is really buggy. I'm running it on two localhost dbs, and it regularly errors when conducting the compare (increasing timeout improves the rate of errors slightly), and I can run it on the exact same db set several times -- each time getting a different result -- most of the time getting the error already mentioned on the resulting tables.

Schema/Data compare are some of the most useful and valuable tools. I'd love to see them working better.

Anyone know if the v5 beta has them working?


jlffool

Posts: 1
Registered: 6/29/10
Re: Schema Compare - and website problem
Posted: Jun 29, 2010 2:46 PM   in response to: bart.baeyens@cr...
  Click to reply to this thread Reply

I got the exact same error. And I'm using the same version. Any progress on this?


Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums