Write a Database Migration Plan

CLOSED
Bids
7
Avg Bid (USD)
$339
Project Budget (USD)
$30 - $250

Project Description:
I have a 25GB database at GoGrid on MS SQL Server 2008 Std Edition. I want to move it to Rackspace. Creating a back and restore of the database is easy, but it takes almost 24 hours to send it from the GoGrid Datacenter to Rackspace over the internet. I need to ensure the system is not down for that much time. So, I am thinking I should do the following:

1. Backup the GoGrid Database
2. Send it to Rackspace over the internet (takes 24 hours)
3. Restore it on the new Rackspace server'
4. Test to make sure it works ok.
5. Stop the GoGrid Server and put up a maintenance notice
6. Do some sort of differential backup and send that to Rackspace (presumably it would take a small amount of time to transfer a differential copy of the DB)
7. Restore the differential on Rackspace, test.
8. Redirect traffic to the new system.

I'm clear on steps 1, 2, 3, 4, 5, and 8. What I'm not clear on is the best method to move the differential data over to the new SQL server and restore it over there. Only data would be changing. Stored procedures and users I will take care of in step 3.

What's the best way to move the differential data? What steps would be involved? Is there a better way overall than this? Those are the questions I need answered as the deliverable of this project.

Thank you!

Skills required:
Database Administration, Microsoft, SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire peterredei
$ 1000
in 1 days
Hire vhrios
$ 250
in 5 days
$ 250
in 5 days
$ 170
in 1 days
$ 250
in 10 days
Hire vivekrnema
$ 250
in 7 days
Hire Caronettech
$ 200
in 5 days