Home > Blockchain >  How to store hot and cold data with Azure SQL
How to store hot and cold data with Azure SQL

Time:09-30

I have a huge order table in Azure SQL. I have one boolean field "IsOrderActive" to separate hot and cold orders. Is it possible to automatically transfer cold data to a separate database with Azure SQL?

CodePudding user response:

enter image description here

  1. Left click on database name where you have order tables and click on Generate Scripts...

enter image description here

  1. Select Select specific database objects and mark the objects for which you want to create script as shown in below image.

enter image description here

  1. Set the below settings.

enter image description here

  1. Review the details and click on Next. This will generate your script.

enter image description here

Go to the location where your script got saved. Open the file in any editor and copy the script.

  1. Now in Azure Portal, go to the database where you want to transfer the cold data table. Go the the Query Editor and paste the copied script in the white space. Run the script and you will get the tables in this database as shown below.

enter image description here

  • Related