[Khushboo]

HI,

Thank You for your feedback and valuable comments.

The colors which we selected for the dropdown are the colors which were looking good with SQLyog interface and ofcource they were mostly light colors.

But we will discuss about your request of “Adding two or three dark colors to the dropdown”.

Regards,

Khushboo

[Khushboo]

Hi,

We have released SQLyog 8.3 Beta1 with two new features “Save Session” and “Support for Table Alias” in Query Builder, which is available publicly!

A Query Builder session can now be saved and resumed.

In Query Builder a table alias can be defined for any table by double-clicking the title bar of the table symbol.

Please refer to:

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

Thank you.

Regards,

Khushboo

[Khushboo]

Hi,

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

Added an option to define a ‘color code’ for a connection. The color will be used as background color in the Object Browser.

Please refer to:

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

Thank you.

Regards,

Khushboo

[Khushboo]

Hi,

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

Added an option to define a ‘color code’ for a connection. The color will be used as background color in the Object Browser.

Please refer to:

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

Thank you.

Regards,

Khushboo

[Khushboo]

Hi,

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

Please refer to:

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

Thank you.

Regards,

Khushboo

[Khushboo]

Hi,

Your request is added in our issue tracker.

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

We cannot currently tell the priority of this. We are fully booked for the moment but we will try to consider this as soon as possible.

Thanks for reporting!

Regards,

Khushboo

[Khushboo]

Regarding :

Quote:

Also as a suggestion for enhancement I would like to see a button in the “Table Data” tab that would let me see the last X rows of the table without my having to figure out how many rows are there first.

This feature request “Buttons should be added in Table data to go to First and Last record” is already in our issue tracker,

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

Currently we are working on “Page wise retrieval mechanism for Result Tab”, after this implementation, we will prioritize your feature request accordingly.

Thanks & Regards,

Khushboo

[Khushboo]

Hi Noble,

We are looking into this issue, in the mean while can you please check that the tables which you are importing consists of primary keys or not?

Usually importing tables without primary keys and large data, is slow with ODBC driver.

We checked the same case for tables with primary keys, both tables and views(with primary key columns) are importing fast.

Please use primary keys for your tables and try to import tables and views through Import External Data.

Regards,

Khushboo

[Khushboo]

Hi Andrew,

Thank You for reporting this issue and for your feedback.

This fix will be included in next public release 8.3 Beta1, releasing probably next week.

Regards,

Khushboo

[Khushboo]

Hi Noble,

We are looking into this issue with high priority.

We reproduced your case at our end.

The issue is with views containing OUTER and INNER JOINS and with large data.

We will update the status soon.

Thanks & Regards,

Khushboo

[Khushboo]

Hi Andrew,

Quote:

When I save the job and run it through the SQLyog Job Agent on the command line such as

“C:Program Files (x86)SQLyog Enterprisesja.exe” “C:import.xml”

data is truncating through that. This may be expected since you may have just updated the Import External Data process and not the SJA yet.

SQLyog Job Agent(SJA) on the command line must work if Import External Data wizard is working fine as you expected.

We checked your case in SJA on command line and its working fine.

Please check the version of SJA which you used? It should be SQLyog Job Agent 8.23.2.

Also, can you please install SQLyog in new path and check the case again.

Thank You.

Regards,

Khushboo

[Khushboo]

Hi Andrew,

We were able to reproduce this issue in our environment.

For Universe database, ODBC driver is not returning correct string length. So, we found a workaround.

We are checking for all the cases, in the mean time please try this special build 8.23.2 (not release) in your environment and let us know the status.

http://www.webyog.com/downloads/betas/not_released/SQLyog823.2.exe

Note: We have one limitation, while importing if data size is more than 32K, then only 32K data will be imported.

Thank You.

Regards,

Khushboo

[Khushboo]

Hi,

We are looking into your case, in the mean while can you give us more details:

1.

Quote:

However, it seems to truncate some of the data at 20 characters.

Can you please tell whether this truncation of data is for a specific data type or for all?

2. Which UniVerse database you are using Ardent Universe Database or IBM Universe Database?

3. Have you tried to import data from UniVerse database to MS Access? Is it also truncating data?

Thanks & Regards,

Khushboo

[Khushboo]

Hi,

At present SQLyog does not have an option to change Font Size of Object Browser pane.

But this option is present in Tools –> Preferences –> Editor (See the screen shot) for other places like SQL Editor, History, Info, Blob Viewer and others (Table Data Tab and Result Tab).

Regarding changing Font Size of Object Browser pane, we will discuss and let you know that status.

Thank You.

Regards,

Khushboo

[Khushboo]

Hi,

We are glad you loved our product SQLyog.

Regarding the crash:

1. Can you please reboot the OS?

It could be an issue with Windows 7 'Data Execution Prevention (DEP)' feature that is not quite stable. A reboot will normally solve this. Please reboot and let us know the status.

2.You can make an exception in 'Data Execution Prevention (DEP)' settings for the SQLyog.

3.If still the issue still persists, please attach the dump, so that we can try at our end.

Thanks & Regards,

Khushboo

[Author]

Posts