[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

[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

[b_harris]

Yes! Thank you.

I have often used the filter feature provided on the table view tabs and thought to send in a request to allow setting a value free form instead of the cell value which is always chosen for us. Since my eyes have never wandered past the first menu choice, I apologize for not seeing this feature earlier. Maybe it was due to my scrolling through hundreds of record to find the one row that had the cell value I want to use with the first filter menu choice. 😆

So,I only recently noticed this 'custom filter' menu choice and to my surprise it was exactly what I was always hoping for.

Great Job!

Bob

[b_harris]

Hi

I'm using newly purchased.. SQLYpg Enterprise 4.07 editions. Great….great tool!

I run into the Error 1045 when I have connected initially to a remote database and then connect to the localhost on my PC second.

Trying to perform a Structure Sync I received the following error…

Error No. 1045

Access denied for user: '[email protected]' (Using password: Yes)

To get around this I closed all connections, re-connected to local first and then remote second. It allowed Structure Sync tool to work perfectly but afterwards I could not execute the batch file from SqlYog…I had to cut and paste into the SQLYog's Query area and execute from there.

Also during this session SQLYog Database Sync tool failed with the same error when I attempted to select a database from the dropdown that was associated to localhost. So it appears that there are inconsistancies invoking authentication from different tools.

I don't understand why .localdomain is being attached to the user credentials for any localhost reference but that could be why that user id is being denied access.

BTW: this all occurred for SSH Tunneling connections. It works fine for HTTP Tunneling via the remote webservice php file.

Could some one respond with a possible workaround for this issue?

Your help is appreciated.

Bob

[b_harris]

Thanks for the very timely information!

Bob

[Author]

Posts