SQL Azure - On Premise Sql Server (Slowly Changing Dimension) RRS feed

  • Question

  • Hi,

    Objective: Sync On premise sql server table with sql azure (every hour) but without using Triggers on the table (sync frame work). 

    I was using syn framework 2.1 for synchronizing the data between on premise and sql azure. But i ran into problem because of the trigger created on tables. For few tables i can't have triggers because it will break the existing application so i thought of sync those tables using slowly changing dimension from SSIS which is nothing but upsert logic. But for Azure we can use only ado.net connection and not the oldedb connection manager so i am not able to use the SSIS slowly changing dimension. 

    I would appreciate any help on this. Thanks in advance.


    Tuesday, March 8, 2011 10:13 PM