samedi 1 août 2015

run migration script in disconnected mode in sql server

can I run migration script in disconnected mode or when connection disconnect than it can be start from last stop. my migration script is taking approx. 2 hrs ,because there are too much data and lots of logics.when we start migration one to another database by this script, than sometimes connection disconnected or light off etc. problems..than data rollback automatically , so I want that when sql disconnect or light off than can we stop migration and when it comes in connected mode,it will start from last stop..is it possible ???

Aucun commentaire:

Enregistrer un commentaire