Steve Jones - SSC Editor (2/9/2016)
For reference data, some people are trying to move towards something like MDS, which gives you a central place to store and get data from that need standardization.For non reference or lookup data, there are really two main ways.
- scheduled ETL movement using something like SSIS, custom scripts, or some other tool
- more real time movement with replication.
Thanks, I'll have a look into MDS (which is new to me).
Problem is that I am looking into somethins more generic, maybe a datadriven solution. Not a solution where each export/import needs specific coding.
thanks for your input,
Ben