INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Default to Replicate timestamp as binary

Default to Replicate timestamp as binary

(OP)
Is there a way to set Replicate timestamp as binary as the default for replication?

I am building a data mart/warehouse. I have several source databases that are replicated to my server. I want to use timestamp (now rowversion) columns to determine which rows need updating for a differential build. I have written a procedure that checks for tables that do not have a timestamp column and adds the column.

My problem is reinitialization of existing publications and creation of new publications. If the DBA forgets to check the Replicate as binary checkbox then I don't get my timestamps.

Is this setting the only way to capture timestamps or is there a trick to getting binary timestamp values through replication without it? I thought about a computed column that casts the timestamp as binary. Replication does automatically add the new computed column on reinitialization but from what I've read replication will only transfer the formula not the data, so it will probably fail on the subscriber. I haven't tested that though.

--JD
"Behold! As a wild ass in the desert go forth I to my work."

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close