question

MrBoo-9896 avatar image
0 Votes"
MrBoo-9896 asked OuryBa-MSFT commented

Overwrite Training Sql database on the Production database

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

129918-a1.png


azure-sql-database
a1.png (115.3 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Are you talking about schema changes only or you want to update Production data with the data coming from Training DB?

0 Votes 0 ·

Both Schema and Data change sir. That's why I wanna overwrite the whole training database on the production database.

0 Votes 0 ·

1 Answer

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT commented

Hi @MrBoo-9896 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://docs.microsoft.com/en-us/azure/azure-sql/database/database-copy?tabs=azure-powershell

Let us know if that help

Regards,
Oury

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MrBoo-9896 Were you able to check the above answer I provided in response to your question.?

Regards,
Oury

0 Votes 0 ·

Hi @MrBoo-9896 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

0 Votes 0 ·