0

I need to move data from tst DBaaS to acc DBaaS, DBaaS are not connected as azure resource or something like that.

Im trying to select some data from DBaaS A and insert it in DBaaS B using Linux Agent. I have connections and passwords, user names are valid, i can see selected data in logs.

But how to make SELECT X FROM A and then INSERT X INTO B?

pool: name: LinuxAgent

variables:

  • name: a_name value: a_value

  • name: a_connection value: a_connection

  • name: b_name value: b_value

  • name: b_connection value: b_connection

stages:

  • stage: pull displayName: Pull data from DBaaS jobs:
    • job: pull steps:
      • task: Bash@3 displayName: Pull data inputs: targetType: 'inline' script: | sqlplus ${{ variables.a_name }}/PASSWORD@'${{ variables.a_connection }}' <<< "select query"
  • stage: push displayName: Push data to DBaaS dependsOn:
    • pull condition: succeeded() jobs:
    • job: push steps:
      • task: Bash@3 displayName: Push data inputs: targetType: 'inline' script: | sqlplus ${{ variables.b_name }}/PASSWORD@'${{ variables.b_connection }}' <<< "insert query"`

My pipeline knowledge is pretty poor so beside of log query statement i have no idea how to store it and pass further...please help :)

Improve this question
1
  • Looks like you are using Azure DevOps as a data integration tool. This is not reccomended. But if you really want to proceed with this approach, you first need to export the data to a flat file dba.fyicenter.com/faq/oracle/…. This flat file will exist in a DevOps working directory. Then you need to import it with SQLLoader blogs.perficient.com/2017/03/03/… These two steps need to different jobs in the same stage otherwise you lose the intermediate flat file
    – Nick.Mc
    Jul 28 at 6:41

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.