Syncronize 2 Databases – Strucrture And Data

[Nadav]

Hello,

I'm looking for the easiest way to sync 2 schemas – QA and Production.

My story is that the QA gets alot of updates on his schema and in some point at time we decide to upload all the changes into the production schema.

I don't want to run all the updates one by one.

I want to create a diff script automatically that will upgrade the production schema.

I saw there are 2 tools in the SQLYog – structure compare and DB sync which may do the job but in many steps.

What i'm looking for is a way to create an sql after the compare between the 2 schemas but that will include both structure and data.

Thanks Nadav

[peterlaursen]

With SQLyog you will have to execute

* structure sync

* data sync

in that order

“I don't want to run all the updates one by one.

I saw there are 2 tools in the SQLYog – structure compare and DB sync which may do the job but in many steps”

>> no in TWO steps – not MANY steps

I want to create a diff script automatically that will upgrade the production schema.

>> structure sync will 'generate a script', data sync will not 'generate a script'. data sync if implemented in the SJA, that is a compiled binary. BINARY .. not SCRIPT.

[Author]

Posts