How can we help you today? How can we help you today?

Suggestion: add values to non compared columns

It would be nice if, for non-compared columns, it would be possible to configure the value to assing in the synchronozation script.

Good options would be:
    Same as source Constant function call (like GETUTCDATE())
paulo_morgado
0

Comments

4 comments

Sort by
  • peter.peart
    Hi Paulo,

    Many thanks for your post. Sorry, but I am not entirely sure what it is you are after here.

    Are you looking to be able to assign default values to not null columns when you are performing a comparison or something else?

    Many thanks!

    Pete
    peter.peart
    0
  • paulo_morgado
    Not just that.

    Imagine I have a SS2000 or SS2005 database with a table with DATETIME column and a SS2008 version of the same database where the table has DATETIMEOFFSET(0) instead of DATETIME columns. Chances are that values from one will never be equal to values in the other because DATETIMEOFFSET(0) has no milliseconds part.

    Another use case is where I have a timestamp column that I don't want in the comparison but, in the synchronization script I want it to be GETUTCDATE().
    paulo_morgado
    0
  • peter.peart
    Hi Paulo,

    Thanks for that. I have added a feature request in our systems for you under reference SDC-1143 and this will be reviewed for the next release of the tool. As soon as there is any movement on this request I will let you know.

    Pete
    peter.peart
    0
  • paulo_morgado
    I Can't hardly wait.
    paulo_morgado
    0

Add comment

Please sign in to leave a comment.