Forum Discussion

johnt75's avatar
johnt75
Icon for Super User rankSuper User
6 years ago

Changing servers for incremental refresh but keeping data

I'm looking to set up an incremental refresh dataset which will load in over 1 billion rows. 

My setup includes a live clone DB and a mirror which is refreshed daily. I cannot load all the data from the clone as it takes so long that it is failing, as the primary DB tries to update the clone, so I want to do the initial large load of data from the mirror. Once that has completed I want to change the setup so that the daily incremental refreshes are looking at the clone and not at the mirror, but I obviously don't want to lose all the data which was loaded in.

Is this possible?

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    johnt75 , As far as I know, you can change Database connection  This is also true when moving from dev to production.

     

    parry2k , can this be done. Change server for incremental and Initial?

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      johnt75 great question. I'm not 100% confident about what will happen if you change the connection after the initial full load. I would do a test with small dataset and then go live with it. In theory, it should work.

       

      I can test it at my end but it will be next week. Thanks amitchandak for reaching out.