question

SwapnilSolanki-4729 avatar image
0 Votes"
SwapnilSolanki-4729 asked pituach edited

Moving 7TB of data from Azure IAAS database to Hyperscale

I have got one huge database of 7 TB on Azure IAAS . I am migrated the schema of database to Hyperscale.
Now i am planning to migrate data, which service should i use to do the same.
I have heard about Database Migration Service, Does that work for Azure IAAS to Azure Hyperscale?
NOTE: Azure data factory is not an option in my case

azure-database-migration
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.

1 Answer

pituach avatar image
0 Votes"
pituach answered pituach edited

Good day,

I have heard about Database Migration Service, Does that work for Azure IAAS to Azure Hyperscale?

If by Azure IAAS you mean SQL Server on Virtual Machine, then the answer is yes. The procedure is the same as from local server at home basically.

With that being said, I am not sure how well it will work on such size and how complex is your database structure, and I am not sure that this is the solution which I will select for such size of database.

Note: You should think about the option of using Replication (publisher only on-premisees / VM, Azure DB only as push subscriber). This option allow you to keep working with the old database while it replicated to the new database for testing. Once the procedure was tested and you sure your app can work with the old database then you can simply make the final closure (replicate) and remove the old database safely since you already tested everything.

I am migrated the schema of database to Hyperscale. Now i am planning to migrate data, which service should i use to do the same.

Most of the issues in migrating from SQL Server to Azure Database are related to the schema and server level entities. If you already migrated the schema well, and you finished to design your database structure as Azure Database, and you 100% sure that you only need to migrate the data to tables, then you can use simple solutions in the tables level.

You can use bcp for example (remember that you might need to disable constraints and other limitation for the task like SET IDENTITY ON for example).

NOTE! Very important! in my opinion You should not migrate the old database structure automatically (especially in databases in such size) but design the database almost from scratch to fit best the new environment.

I have got one huge database of 7 TB

Off-topic... I am not sure if you can consider 7 TB as a huge database. I would say that 100T is the bottom limit for a database to be considered as huge but this is just a semantic. Did you know that SQL Server Max Database size is 524,272 terabytes - more than half a million terabytes (notice that this is in terabytes and not GB) 🙄







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.