Post reply

Binary Comparision of tables

  • July 16, 2009 at 8:06 am

    #132970

    Hi All

    I would like to do a binary comparision for my tables as it has billions of records.

    Please let me know how can I do in SSIS

    Thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • July 16, 2009 at 8:17 am

    #1025681

    Huh? Are you talking about a row-by-row comparison, or something else? What do you mean by binary - are you referring to a checksum?

    More detail needed about why you are doing this and what results you are expecting please.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • July 17, 2009 at 12:32 pm

    #1026378

    Hi Phil,

    thanks for your Reply.

    Actually I have a very large dimension table that is updated but not very frequently......

    So I cannot check for every row if some thing as changed as it will take lot of time, So I want to compare it in an intelligent way...to check if sumthing has changed and so I was thinking to use some BINAY comparision...

    I have never done this before...

    How to use checksum?

    Any help on this...

    Thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • July 17, 2009 at 12:57 pm

    #1026393

    Assuming that you are updating existing records, why not put a ModifiedDate column on the table and update that column when you update the row? Then you just have to query on a date range to know what records were modified.

  • July 17, 2009 at 1:33 pm

    #1026411

    Are you using Enterprise Edition?

    If so, read about CDC (Change Data Capture).

    N 56°04'39.16"
    E 12°55'05.25"

  • July 17, 2009 at 3:23 pm

    #1026460

    Peso (7/17/2009)

    Are you using Enterprise Edition?

    If so, read about CDC (Change Data Capture).

    Isn't that a SQL Server 2008 feature?

  • July 17, 2009 at 3:29 pm

    #1026464

    Sure. I forgot to see which version it was.

    😀

    N 56°04'39.16"
    E 12°55'05.25"

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply