What are the challenges you face when working across database platforms? Take the survey

SQL Compare Version 3.1.0 synchronization question

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 25, 2005 9:47AM in SQL Compare Previous Versions
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.


Brian Donahue
Red Gate Technical Support

"Bill Shum" <bill.shum@caphealthg.org> wrote in message
> 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
> 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
> 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
> 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


This discussion has been closed.