[navyashree.r]

Sorry, here's the correct link,

http://code.google.com/p/sqlyog/issues/detail?id=1100

Regards,

Navya

[navyashree.r]

Sure Smine,

Undoubtedly, SQLyog can perform this action.

You can use “Schema Synchronization tool” from Powertools menu or simply click Ctrl+Q.

It's a visual comparison/synchronization tool where you can just 'compare' between different databases across different MySQL servers. It shows the differences between tables, indexes, columns and routines of two databases, and generating scripts to bring them in Sync.

Just by comparing the databases, it won't sync the databases. Only when you click on EXECUTE ALL button, it syncs. So, you can see the difference by clicking on COMPARE button.

For more info please read our HELP document.

Regards,

Navya

[navyashree.r]

Hi Keith,

Issue is added in our issue tracker,

http://code.google.com/p/sqlyog/issues/detail?id=1253

Thank you. We will discuss with other team members and come up with better GUI and set the priority too and update.

Regards,

Navya

[navyashree.r]

Hello,

We have released SQLyog 8.31 Beta1 which is available publicly with this fix.

Refer to:

http://www.webyog.com/blog/2010/03/19/sqlyog-mysql-gui-8-31-beta1-has-been-released/

Please evaluate and let us know the status.

Thanks & Regards,

Navya

[navyashree.r]

Hey Steavy,

Yes, you can sync SQL server table to MySQL table through Import External Data (Ctrl+Alt+O) from SQLyog's Powertools menu using ODBC.

After selecting table to be synced, you can further use 'DDL/DML optins' in 'Advanced Options' where you can sync or import datas to existing table (both Source and Target tables has same structure) or you can recreate the table by using this option.

See image “import.jpg”

Regards,

Navya

[navyashree.r]

Hi,

We have released SQLyog 8.3 Beta2 with this feature, which is available publicly!

Quote:

But you do have an option to do page-wise display in both DATA and RESULT tab and that is what we recommend.

How can I select “page-wise display”? Which option must I select in which window?

In RESULT tab results can now be retrieved page-wise (same as the Table Data tab) by executing a SELECT (with out Limit clause) query. This is ON as default with this build with a defined LIMIT of 1000 rows. For a specific query user can change and for this specific query the setting is persistent across sessions. Also read ‘miscellaneous’ paragraph below under Beta1 section.

FYI:

http://www.webyog.com/blog/category/sqlyog/

Regards,

Navya

[navyashree.r]

Oops Sorry…

The crash dump path I gave was wrong

Correct path is here for Windows 2K/XP/2003:

C:Documents and Settings{user}Application DataSQLyog

Regards,

Navya

[navyashree.r]

Hi Marco,

Quote:

If I open table “white_subscriber” with number of Rows = 1,400,000 rows. SQLyog don’t disappear, but has the process status “not responding”. At the moment it 'crashes' there will appear more than 1 copies of “SQLyog Trail..”

We are already prompting 'Not enough memory' in some places (For example: if Blob data is crossing the memory limit). Please attach the dump file, so we can analyze where it crashed exactly.

Crash Dump path:

Windows 2K/XP/2003:

C:Application Data{user}SQLyog

Windows Vista/2008/7:

C:Users{user}AppDataRoamingSQLyog

Quote:

Mem.zip is little program to monitor the current memory usage.

Thank You for your valuable suggestion. We will discuss about this and update.

Regards,

Navya

[navyashree.r]

Hi,

We have added this feature request in our issue tracker,

http://code.google.com/p/sqlyog/issues/detail?id=1242

As we said we will discuss about this feature and set priority accordingly. Right now we are piled with new features in the upcoming future. Also we went with 8.3 beta1 release publicly yesterday.

You can read our blog,

http://www.webyog.com/blog/2010/02/18/sqlyog-mysql-gui-8-3-beta-1-has-been-released/

We will update you once we discuss about this.

Thanks for your suggestion.

Regards,

Navya

[navyashree.r]

Hi,

We have released SQLyog 8.3 Beta1 with this feature, which is available publicly!

“In RESULT tab results can now be retrieved page-wise. This is ON as default with this build with a defined LIMIT of 1000 rows. For a specific query/resultset user can change and for specific combination of query, database and table the setting is persistent across sessions.”

Also please go through 'miscellaneous' in the link given below.

Please refer to:

http://www.webyog.com/blog/2010/02/18/sqlyog-mysql-gui-8-3-beta-1-has-been-released/

Thank you.

Regards,

Navya

[navyashree.r]

Hi,

We have released SQLyog 8.3 Beta1 with this feature, which is available publicly!

“In RESULT tab results can now be retrieved page-wise. This is ON as default with this build with a defined LIMIT of 1000 rows. For a specific query/resultset user can change and for specific combination of query, database and table the setting is persistent across sessions.”

Also please go through 'miscellaneous' in the link given below.

Please refer to:

http://www.webyog.com/blog/2010/02/18/sqlyog-mysql-gui-8-3-beta-1-has-been-released/

Thank you.

Regards,

Navya

[navyashree.r]

Hey Andrew,

Its just a work around. We are still looking for all the cases. Yes, this issue still exists in SJA.exe and not yet coded for SJA.

This fix along with major features, will be available in 8.3 beta expected to release within few days say by next week (Friday).

Thank you & Regards,

Navya

[navyashree.r]

Hi,

Thank you for your wonderful support.

This feature is already developed and its given for testing. We may release this “Colored interface based on connection” along with other major features within few days say by next week (Friday).

Regards,

Navya

[navyashree.r]

Hi Andrew,

Issue is confirmed. Using this Universe ODBC, data is truncating when we import from Import External Data tool.

Our colleague is looking into this issue. We will update the status once we find the solution.

Thank you for reporting this issue and help us nailing down the problem.

Regards,

Navya

[navyashree.r]

Hey John,

Also, can you please confirm which SQLyog version you are using?

And please try with the latest 8.22 SQLyog version and confirm whether this is reproducible or not?

8.22 SQLyog from our DOWNLOADS page,

http://www.webyog.com/en/downloads.php

Please help in nailing down this issue.

Regards,

Navya

[Author]

Posts