Brian DonahueBrian Donahue Posts: 6,590 New member
edited November 9, 2005 7:21AM in SQL Compare Previous Versions
Hi Kirk,

My name is Brian Donahue and I am a support engineer with Red Gate
Software. This is a fairly easy fix. Under Options, de-select the 'Generate
SQL 7 compatible scripts'. SQL Server 7 does not support UDFs, so the
migration SQL will not be generated.


Brian Donahue

Technical Support Engineer

Red Gate Software Ltd.

( +44 870 1600 037

* mailto:[email protected]

"Kirk" <[email protected]> wrote in message
news:[email protected]
> I have compared two databases. One has two UDF's it and the other doesnt.
> When I run the compare, it lists them, but when I create the script, the
> script does not. Is there something I'm missing?
> Thanks
> Kirk


  • Brian DonahueBrian Donahue Posts: 6,590 New member
    FYI -- This information applies to products in the 2.x versions of SQL Bundle. SQL Compare 3 and up no longer have a 'create SQL 7 compatible scripts' option. To get SQL Compare to create, as closely as possible, scripts that are compatible with SQL Server 7, please use the following options:
    • Ignore collation order
    • Ignore INSTEAD OF triggers
    • Ignore extended properties
    • When you select the objects to synchronize, ensure user-defined functions are not included for synchronization.
    In addition, you may need to modify the synchronization script manually to remove references to features that are not supported, for example, computed columns containing user-defined functions, and ON UPDATE/DELETE CASCADE.
This discussion has been closed.