Bug: Schema Sync Produces Errors

[Dave Mednick]

I am a newly registered user of SQLyog 8.3 Ultimate. One of the main reasons I purchased the software was to perform synchronization between three databases that are in different stages of development. However, when using this very powerful and time-saving tool, I receive “no database selected” errors. I have nearly identical dbs selected on two different servers as source and target. I use the “compare” function with “Delete from target” unchecked. I receive a resulting SQL query in the bottom box and click the “Execute All” button. These same resulting SQL queries work fine when copied and pasted into the query builder window. It is as if the tool is selecting the target db for comparison purpose but not for execution.

Thanks

[Mahesh]

Using Schema sync tool you can compare two schema and make them sync by executing queries there itself on click of “Execute All” button.

There is no need to copy and paste SQL statements to editor and execute.

Please tell,

1) Are you getting this error “No database selected” every time OR only in particular case?

2) Exact source and target MySQL server version?

3) Are you using direct/Http/SSH method ?

4) We need a reproducible test case for both source and target schema?(You can use “Backup database as SQL dump.” tool to backup source and target database)

[peterlaursen]

I guess that server “forgot” the USE statement that we sent earlier.  I remember that could happen with early 5.0 servers.

Please also tell how much time it takes for SQLyog to generate the sync script with your example. 

[Author]

Posts