• 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