Query Profiler Output

[b_harris]

Greeting,

Feature requests:

(1) I have not found any menu choice or setting which would allow this capability but it would be beneficial if the output posted in the query Profiler tab could be saved to an external target as formatted text, html or excel. Although copy and paste is available, the format is purely plain text and is somewhat unusable.

(2) Provide the ability to perform data comparisons across servers and databases. This feature has been available in Quest Software's 'Toad for MySQL' and I find it indispensable when moving changes between develop, staging and production servers. This is currently the only reason I have Toad on my workstation.

Excellent product!

Best regards,

Bob Harris

[peterlaursen]

As regards 2nd point: did you check the 'Schema Synchronization' feature?  If this is not what you are looking for please detail.

[b_harris]

Hi Peter,

Thanks but yes I have looked at the Schema Sync tool. I use it as often as I use the Toad data sync tool. But SqlYog schema sync tool does as its title indicates, it only performs syncronization of the database structure and meta definition not of its data content in the tables.

Data syncing as I speak of it is comparing the content of similar tables in other databases on local or remote server locations and then providing the ability to make the table's data content identical. Comparing row by row and column by column. This is exactly what Toad's Data compare tool does. Once the differences are found the user is then allowed to choose which rows to sync up. Toad then allow the user to designate if a script should be created or if the changes are to be executed in real-time. It is a very useful feature that assists in moving changes from a development server to a test server and then to a production server.

Best regards,

Bob Harris

[peterlaursen]

SQLyog Data Sync also lets you 'generate a sync script' if you don't want to execute directly.

[b_harris]

'peterlaursen' wrote on '16:

SQLyog Data Sync also lets you 'generate a sync script' if you don't want to execute directly.

Hi Peter,

My apologizes, I did look at the SqlYod Database Wizard, and although I think it is useful, it has one feature missing. That is the ability to interactively see the differences and control which records can move between source and target tables. This feature is in Toad and really acts as the standout item.

In site management, I have found that being able to control at the row level which records are to be transferred is very necessary. This is also to the point of allowing the creation a new (auto) index in the target table that is different in the source. I know that every project has its priority. Maybe in the future, the SqlYog team will have time to review the virtues of this request.

Thanks,

Bob

[peterlaursen]

I think we have this request already is some form.  But our Data Sync is an automatic tool primarily.  It is *Data Sync* – ie. it will make tables identical and never intended anything else (except for the WHERE opgtion)

I'd also say that I believe that most of our Data Sync users have tens of thousands of rows in their tables and will not be able to identify the meaning of individual rows manually.

But let us return to this later this week.

[Author]

Posts