I'm watching this amazing video and know about this amazing tool after I finished 6 months data migration (two projects, from oracle to sql server) I used almost all the ways you mentioned in the beginning 😂😅 Thank you for this awesome video
One use case I can see is the creation of 'reporting' databases, separate from operational databases, that can be transformed/optimized on the fly to de-normalized flattened tables for more efficient report queries (less table joins). Do you know if ADF can generate scripts to automate these transformations, such as daily, weekly, monthly, etc.?
Nice tutorial Hassan, one question - what we should do in this scenario: *Source Leagacy database:* SQL Server 2016 (Hosted on on-prem server under enterpsire netwrok), with milion records and SQL objects like Stored Procedures, Views, Triggers, multiple indexes, jobs etc. *Target Modern database:* Azure SQL Server (DTO based or serverless) with blank databnase (no schema yet!) I have tried few ways but still looking for a cleaner and profession ways to do the same! mine version is painful 🤣
@itishmani6601 To access on premise SQL Server, you need to use Azure Data Factory or Synapse workspace Managed Virtual Network using a private endpoint. Refer to this tutorial for detailed steps. learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server
I talks to other cloud providers like Amazon and Google. Check all the lists here: learn.microsoft.com/en-us/azure/data-factory/connector-google-cloud-storage?tabs=data-factory It can also migrate to NoSQL yes.
I'm watching this amazing video and know about this amazing tool after I finished 6 months data migration (two projects, from oracle to sql server) I used almost all the ways you mentioned in the beginning 😂😅 Thank you for this awesome video
Very interesting. Thanks.
When I first saw this, I immediately thought of ETL (Extract, Translate, and Load) tools where you can pipe from storage medium to another.
This is exactly what this is.
wooow, It is amazing. With ADF , we dont need to write million scripts or do backup to migrate data from one db to another. I like it
One use case I can see is the creation of 'reporting' databases, separate from operational databases, that can be transformed/optimized on the fly to de-normalized flattened tables for more efficient report queries (less table joins).
Do you know if ADF can generate scripts to automate these transformations, such as daily, weekly, monthly, etc.?
Nice tutorial Hassan, one question - what we should do in this scenario:
*Source Leagacy database:* SQL Server 2016 (Hosted on on-prem server under enterpsire netwrok), with milion records and SQL objects like Stored Procedures, Views, Triggers, multiple indexes, jobs etc.
*Target Modern database:* Azure SQL Server (DTO based or serverless) with blank databnase (no schema yet!)
I have tried few ways but still looking for a cleaner and profession ways to do the same! mine version is painful 🤣
@itishmani6601 To access on premise SQL Server, you need to use Azure Data Factory or Synapse workspace Managed Virtual Network using a private endpoint. Refer to this tutorial for detailed steps.
learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server
Does it support any other cloud provided rdbms like cloud sql from GCP? Also can we migrate from rdbms to no sql?
I talks to other cloud providers like Amazon and Google. Check all the lists here:
learn.microsoft.com/en-us/azure/data-factory/connector-google-cloud-storage?tabs=data-factory
It can also migrate to NoSQL yes.
Thanks @@HassanHabib