DavidelityI recently bought the enterprise version, a major driver being the structure synchronization tool.
Unfortunately it's incredibly slow. I have a 700+ table database and it takes approx 45 mins on a dual – dual core zeon (ie 4 cores) machine.
CPU use is pretty low, there are spikes to 25% on one of the cores approximately every 5 secs on one cpu, almost as if someone put a 5 sec sleep between table checks or something.
Hope there is some way to speed this up, or you can fix it, otherwise its incredibly annoying for me and will probably use some other tool for structure synchronization.
David
I should have said, I am just wanting to impose the structural changes from one database, A, onto another database, B, maintaining as much as possible of the data in B but changing its structure where necessary. I am not at all interested in getting any data from A into B. Seems like it should be a relatively quick task.
Thanks
David
