Forum Discussion

junior_gong's avatar
junior_gong
New Member
2 years ago
Solved

Azure Database copy table job - Change source table

Hello, I have setup a simple job to copy and overwrite tables from one Azure SQL DB to another Azure SQL DB. Disclaimer - I am new to this.

 

On the initial configuration in the wizard, I defined which Tables would be copied, however I need to make replace one of the tables that is being copied to the destination in the job. How do I change one of the tables that is being copied?

 

Thanks

pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi junior_gong ,

    Based on your problem, I launch SQL Server Management Studio and login to my database.

    Then I think you can follow the steps below:

    1. Choose the database and right click on Tasks and select Generate Scripts.

    2. Select Choose Objects on the left hand side menu and then click on Select Specific database objects on the right part of the window.

    3. When you click on Advanced you will get a list of options, go down to the bottom of the list and select either Data, Schema and Data or Schema only for Types of data to script.

    You can also find more on this blog and it may help you: Copy Data Between Two Azure Databases in Access (accessexperts.com)

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi junior_gong ,

    Based on your problem, I launch SQL Server Management Studio and login to my database.

    Then I think you can follow the steps below:

    1. Choose the database and right click on Tasks and select Generate Scripts.

    2. Select Choose Objects on the left hand side menu and then click on Select Specific database objects on the right part of the window.

    3. When you click on Advanced you will get a list of options, go down to the bottom of the list and select either Data, Schema and Data or Schema only for Types of data to script.

    You can also find more on this blog and it may help you: Copy Data Between Two Azure Databases in Access (accessexperts.com)

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.