SQL Compare Version 3.1.0 synchronization question

Brian Donahue

Hi Bill,

Thanks for writing. This seems to be a bug in the software. We've fixed
a similar problem for the next version that is related and may be causing
your problem as a side-effect.

In the meantime, you might want to try filtering your synchronization
down to tables only (with include dependencies turned off), then migrating
everything else.

Regards,

Brian Donahue
Red Gate Technical Support

"Bill Shum" <bill.shum@caphealthg.org> wrote in message
news:fF8SxpNxDHA.1668@server53...
> Hi.
>
> I'm trying to create the scripts for all the objects within a database so
> that another site can run the script on their own server. I created an
> empty database and ran the SQL compare between my real database and the
> empty one. The GUI listed the objects within the database in the order of
> tables, views, procedures, logins, etc. When I selected the "Synchronize"
> button and follow through on the wizard, the script is creating the
objects
> in the order of their dependency. That is, when a table is script, and it
> has views using that table, it scripts the views next, but other tables
> used within the view have not been scripted. The end result is when I run
> the complete script, the Create View sections fails, complaining some of
the
> table objects are not known.
>
> I have tried unchecking the "include database dependent object" box in the
> first screen of the Synchronize wizard, but the generated scripts are
still
> in the same order.
>
> is this a bug in version 3.1.0 , or is there a way to get SQL Compare to
> generate the scripts for all the tables before scripting the views.
>
> thanks
>
> Bill Shum
>
> Vancouver Island Health Authority - South Island
>
> Email: Bill.Shum@caphealth.org
>
>
>

Brian Donahue

I would imagine that the new dependency routine in 3.15 had fixed this problem...