This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 60%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Hello sir ,
Please see that attachment screenshot .
I have two databases. One is the Production database ("LawDB") and the other one is the Training Site Database ("LawDB_Training").
Now, Training Database ("LawDB_Training") have a lot of database changes.
Therefore, I wanna copy Training Database ("LawDB_Training") and wanna overwrite that training database on the Production Database("LawDB").
So that, Production Database will get the latest version.
But I don't know how to do it in the Azure Portal.
If anyone knows this one, Please kindly give me the step by step instructions.
Many Thanks
Best Regards
Htet
Are you talking about schema changes only or you want to update Production data with the data coming from Training DB?
Both Schema and Data change sir. That's why I wanna overwrite the whole training database on the production database.
Hi @Mr Boo Thank you for posting your question.
You cannot overwrite it. You will need to create a copy of LawDB_Training database and then rename to "LawDB".
https://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?tabs=azure-powershell
Let us know if that help
Regards,
Oury
Hi @Mr Boo Were you able to check the above answer I provided in response to your question.?
Regards,
Oury
Hi @Mr Boo Were you able to check the above answer I provided in response to your question.? If the answer provided was helpful. Please mark as accepted answer. Otherwise let us know how we can better assist.
Regards,
Oury