[Ritesh]

To ignore foreign key constraints during data sync check Set FOREIGN_KEY_CHECKS=0 for Target in the Select table(s) that you want to synchronize page of the wizard.

After the sync is over SQLyog will automatically issue the SQL command – Set FOREIGN_KEY_CHECKS=0

[Ritesh]

Thank you!!

Give me some time to work on it

[Ritesh]

Thanks I have downloaded them.

Can you mail me a screenshot of the Sync dialog in SQLyog ( part showing the table that is giving error will be helpful )?

Just mark out the “Sync Clipboard…” button that you are clicking to generate the script.

[Ritesh]

I think you are selecting the wrong “Sync Clipboard…” button.

If you click on the right one i.e. the first database, then scripts are generated to bring the second database in sync with the first and vice versa.

What you should do is –

select crn.opportunity as the first database.

select mp15.opportunity as the second database.

click on “Sync Clipboard… >>” on the left side i.e. the first database.

Quote:

What complicates matters more is that it doesn't do this ALL the time. It look like it's about half the time that it 'switches'.

This is because you are selecting the wrong context.

HTH

[Ritesh]

We are trying to duplicate the scenario. We will get back to you ASAP.

[Ritesh]

Can you send me the structure of the table with sample data so that we can work on it and fix any bugs if there are any?

You can mail them to ritesh@webyog.com

[Ritesh]

We are looking at your issues and we will suggest you a suitable solution as soon as possible.

[Ritesh]

I have deleted my last post.

You have to install a proxy client in your workstation. This proxy client would allow you access to hosts outside the firewall. You can then use SQLyog.

SQLyog does not have a built-in proxy client.

[Ritesh]

SQLyog uses Windows Task Scheduler to schedule synchronization. Task Scheduler is only available in Win2K/XP.

Quote:

Unknown column 'cdrmsg' in 'where clause'

There is no table called 'cdrmsg' in the source db.

[Ritesh]

Can you paste the LOAD LOCAL SQL syntax that SQLyog sends to the MySQL server? You can get it from the History.. tab.

[Ritesh]

Quote:

missing in MySQL products is a graphical query builder

This feature is planned for SQLyog Max.

[Ritesh]

Sorry, but you have to try it out on another machine. SQLyog “remembers” the last installation and there is no way to run it again after the trial expires.

If you are not satisfied with SQLyog, we would refund them money ( if claimed within 30 days or purchase )

Pls. check out whether others are providing the following features before taking a decision:

– Blazing speed using Native C API ( NOT an 11MB bloatware! )

– ODBC Import

– Database Sync Tool

– Scheduled DB Sync

– Structure Sync Tool

– Multiple result-sets

– Native Windows Look and Feel!

– Relationship Manager

– Schema Documentation

– Column Reordering

– Very Stable

– Lowest price!

[Ritesh]

So everythings working

[Ritesh]

Quote:

sqlserver on my pc and wanted

I hope you mean MySQL and not MS SQL Server

Neway, install SQLyog in the other PC. Instead of giving “localhost” in the MySQL Host Address field, give the IP address of the machine in which MySQL is installed.

[Ritesh]

I believe you mean to say that you want to share two databases located at two different MySQL servers.

If I am correct, then you just need to connect to both the server using SQLyog ( you can connect to different server using the same installation of SQLyog ) and sync them using Tools->Database Synchronization Wizard

[Author]

Posts