Schema Synchronization Scripting

[Keith Davis]

I know how to script the data sync, but what about the schema? Can this be done? It's for a failover server we have.

[Mahesh]

Yes.. “Generate script” should contain “Create table … ” statements too, if target database is empty ( no tables present).

We have added this in our issue tracker here http://code.google.com/p/sqlyog/issues/detail?id=1134

BTW: You can use “Schema Synchronization” feature to make schema identical between database(s).

[peterlaursen]

Schema Sync is not scriptable. It is an interactive feature only.

[Keith Davis]

Our database is every changing and the database backup is not empty. I could drop it first, but that means the entire database would have to be written every time – too much additional traffic.

[nithin]

Hello,

I'm sorry to tell you that we don't understand the exact problem you are facing.

From the 1st post we understood like that you wanted to sync your databases but the schema is not same, So my colleague suggested you to use the Schema sync tool to make the schema(source and target) same.

But your last post I didn't understand clearly, Do you want to drop the target database and sync? If so what makes you to do like that? Is it because the schema are different?

please explain the issue in detail step by step so we can help you and provide you the solution quickly.

Thanks

Nithin

[peterlaursen]

I understand you want to be able to run Schema Sync unattended/scheduled. Is this correct?

[Keith Davis]

peterlaursen wrote on Aug 12 2009, 02:48 AM:

I understand you want to be able to run Schema Sync unattended/scheduled. Is this correct?

That is correct.

[peterlaursen]

added to our issue tracker here:

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

also there was an old request:

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

No decisions taken at the moment!

[Author]

Posts