Post reply

Table content comparing

  • April 30, 2009 at 4:31 am

    #131055

    Hi all,

    I need to copy data from oracle table to table in MSSQL 2005. Data on oracle doesn't change every day and because its a big pack of data I need to check if there's some change in table content.

    Can someone help with it?

  • April 30, 2009 at 5:39 am

    #986577

    Is there a 'Date Last Updated' field on the Oracle data? If not, can you add one?

    Initially, you will have to load all the data, but after that, just select those records where Date Last Updated >= last run date.

  • April 30, 2009 at 5:43 am

    #986581

    Adding a ChangeDate would be the most effiect way of doing this,

    If that is not possible you could write some T-sql to compare the data in the rows to see if there are any changes, though depending on how many rows you have this could take a long time..

  • April 30, 2009 at 5:44 am

    #986582

    Just curious, what version of Oracle!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • April 30, 2009 at 6:06 am

    #986598

    Its on oracle 10g database but for me its available only for reading 🙁

    I check tables and from a few thousands to a few milions of rows.

Viewing 5 posts - 1 through 5 (of 5 total)

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