I have MS SQL 2005 Standard that is used actively (new data is added every minute). I need to transfer it to another server (new hosting provider), without losing the data and without downtime.
Is there any way to do it?
I have MS SQL 2005 Standard that is used actively (new data is added every minute). I need to transfer it to another server (new hosting provider), without losing the data and without downtime.
Is there any way to do it?
You might want to look at database mirroring to replicate the data...there's a white paper here.
Replication seems like the most obvious answer; specifically Transactional Replication.