Update OLTP PROD tables RRS feed

  • Question

  • There is a scenario where we have OLTP 3NF PROD tables that source data for an application, now what is the best way to update those tables? In real time do you use SSIS or anything else?

    Note: These are not data warehousing tables.


    Tuesday, April 15, 2014 2:45 AM

All replies

  • You would need to provide more information about what you are trying to accomplish and what obstacles you have.  It sounds like you are wanting to update an application's tables, but where are the updates coming from?  Other SQL tables?  A text file?  Is the data on the same server/instance?  What do you mean by real-time, and what are your expectations for updates in the source to be realized in the destination?

    SSIS is usually one of many options for ETL, depending on what you are trying to accomplish, it may or may not be the best option...

    Tuesday, April 15, 2014 3:11 AM