Hi everyone, we're migrating from onprem to an azure SQL db. (version 6x).
What would be the approach to migrate history tables? Can't find much on the forums that fits our usecase.
Solved
Data migration
Best answer by dpjat
We excluded the DW_Id and some of the automatic hashed fields generated by history tables.
Then on import everything got assigned.
+5Hi
I know it isn’t the newest 6xxx release but many of the suggestions is valid still.
So for History I would choose method 1 as you then export the databases and imports them to Azure SQL using a bacpac export. You don’t need to install anything on a new server, you just need to change the database location from local to Azure and maybe change the authorization method. As long as the data is the same as before it should not complain.
If you want to create new databases, you will have to use some sort of external data transfer to move the history data.
1 person likes this
I've managed to now migrate the data with data factory. Just have to exclude the ID and hashed fields and it works perfectly.
+5Hi
By ID do you mean Primary Key fields, or is it fields similar to hashes that are generated?
How do you then apply these afterwards?
We excluded the DW_Id and some of the automatic hashed fields generated by history tables.
Then on import everything got assigned.
1 person likes this
+5Hi
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
