|
 Although this page of the
dialog should be rather self-explaining, let's consider two
examples of the situations which these two settings control.
Do
changes in UDF make difference? Suppose you use some
EmployeeID in various tables throughout the database. The ID is
just an integer and so it is defined in the older (let's say
production)
database: "EmployeeID
int not null". However you wished
your scripts to look nicer and in the new (let's say
development)
version replaced them with a new user-defined type:
"EmployeeID
TEmployeeID not null". The actual type has
remained INT. Do you wish the Diff to show all such columns as
changed and try to synchronize them?
Do
changes in physical type make difference? Suppose both databases
are now synchronized and define all such columns as TEmployeeID.
Then for some reason you decide that numbers are not good enough
and TEmployeeID must be CHAR(5) instead. You rebuild from scratch
your development database with this new definition and now
comparing with the production version again. Both version have
columns defined via TEmployeeID, but the actual physical types
behind them are different. Do you need the Diff show all these
changes and try to synchronize them?
|
