Post reply

T-SQL Merge over databases in different servers

  • March 14, 2013 at 3:01 am

    #149753

    Hi Folks,

    I would like to know if it´s possible to use the T-SQL MERGE if the source DB is a DB2/AS4000 in a remote server, and the target is a SQL DB in the local server.

    Any comment would be appreciated.

    Kind Regards.

    Paul Hernández

  • March 14, 2013 at 3:08 am

    #1596877

    Paul Hernández (3/14/2013)

    Hi Folks,

    I would like to know if it´s possible to use the T-SQL MERGE if the source DB is a DB2/AS4000 in a remote server, and the target is a SQL DB in the local server.

    Any comment would be appreciated.

    Kind Regards.

    I doubt it, given that DB2 SQL is a different language from T-SQL.

    Why have you posted this in the Integration Services forum, by the way?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 14, 2013 at 3:42 am

    #1596888

    Hi Phil,

    Thanks for your quick answer.

    Then I will create a temporal table to store the records to be update, and then perform a batch or bulk update, I think it is the best option since use a "OLE DB Command" component is too slow.

    I posted it here, because this issue is a part of an ETL proccess and I´m comparing loading strategies, but it could also be posted in the SQL Server 2008 forum.

    Kind Regards,

    Paul Hernández

  • March 14, 2013 at 3:46 am

    #1596891

    Paul Hernández (3/14/2013)

    Hi Phil,

    Thanks for your quick answer.

    Then I will create a temporal table to store the records to be update, and then perform a batch or bulk update, I think it is the best option since use a "OLE DB Command" component is too slow.

    I posted it here, because this issue is a part of an ETL proccess and I´m comparing loading strategies, but it could also be posted in the SQL Server 2008 forum.

    Kind Regards,

    Sounds like a good option. I think you meant 'temporary' rather than temporal. If not, I'd like to know how you would use a temporal table here.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 14, 2013 at 3:50 am

    #1596892

    Hi Phil,

    It was a language mistake due to my level of English, which sometimes is not good enough 😀

    You are right; the correct term is “temporary”

    Thanks for your remark.

    Paul Hernández

  • March 14, 2013 at 3:53 am

    #1596894

    Paul Hernández (3/14/2013)

    Hi Phil,

    It was a language mistake due to my level of English, which sometimes is not good enough 😀

    You are right; the correct term is “temporary”

    Thanks for your remark.

    No problem. That's a shame - I was quite looking forward to an innovative temporal solution 🙂

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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