Azure Database copy table job - Change source table

[junior_gong]

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

[Anonymous · Accepted solution]

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.