T-SQL Merge over databases in different servers

  • 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
  • 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?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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
  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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
  • 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 🙂

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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