I have an exact copy of DB2 data in a denormalized instance of Azure SQL. As new transactions are added to that denormalized database in the cloud, I would like that data to then flow to a normalized version of Azure SQL. Can I accomplish that using Azure Data Factory?
Data Migration from Denormalized to Normalized Versions of Azure SQL
69 views Asked by IMOsiris At
1
There are 1 answers
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in AZURE-SQL-DATABASE
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- Tools for fast aggregation
- Hoiw can i remove all ip addresses from Azure SQL Server Firewall Rules , but still login via SSMS?
- Small percentage of parameters cause very slow queries
- Azure Functions v4 in Private vNet Cannot Connect to Azure Sql
- Does bcp utility support Token based Authentication? If yes, I would like to know the process and which version of bcp to be used
- "Error: Could Not create constraint or index. see previous errors" with nest js and AzureSql
- Recreating an existing edmx in Visual Studio Code for Azure Function
- How to use parameter in Azure sql_input with LIKE SQL command
- How to Process a CSV File from Power Apps/Automate into SQL Server
- Unable to connect to Azure SQL from Azure Data Factory
- Table gets promoted with no data to Prod for Azure SQL database through Azure DevOps
- System Assigned identity failed to connect to SQL Server database
- Optimal approach in accessing datalake container with multiple teams?
- Azure SQL support for Delta tables
Related Questions in DENORMALIZED
- Mapping unnormalized database into graph
- Merging denormalized data into a relational structure
- Data Migration from Denormalized to Normalized Versions of Azure SQL
- Count entries grouped by id and month from denormalized database
- XML Export - Denormalized Data
- Creating denormalized tables with triggers too slow
- How to flatten a nested json array?
- How to reuse values from multiple columns in the select statement of mysql
- Cost (%CPU) around the same after denormalization?
- Convert comma delimited values in a column into rows
- How do I denormalize an ER-D into reporting views for end users?
- Indexing a Denormalized Table on Perfectly Correlated Int and VarChar
- How convert string to int with Symfony Serializer
- calculate gaze velocity in VR using normalized direction
- pandas dataset transformation to normalize the data
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Don't use triggers. Use Change Data Capture (CDC).
It's a rather new feature, but promising. Try out new features. Note there are some requirements like having a S3 tier. There are loads of other things, from ADF to Functions. ADF even has a CDC function of its own: https://learn.microsoft.com/en-us/azure/data-factory/concepts-change-data-capture is helpful to CDC to other destinations and do transformations.
You can even stream your data, with something like Spark structured streaming or ASA. The cheapest option will always be to write your own delta loads.