Ditutup

Write a Database Migration Plan

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!

Kemahiran: Pentadbiran Pangkalan Data, Microsoft, SQL

Lihat lebih lanjut: sql database migration plan, sql migration plan, database migration project plan, sql migration project plan, server migration plan, database migration plan, write data migration plan, write migration plan, sql server migration plan, sql 2008, sql migration project, migration plan, project plan sql migration, sql database migration project plan, sql server 2008 migration project plan, database migration plan sql server, database server migration project plan, what is ms project plan, sql server migration project plan, what is ms sql, write some sql for a project, Time plan, datacenter, care plan, backup database

Tentang Majikan:
( 150 ulasan ) New York, United States

ID Projek: #4108326

6 pekerja bebas membida secara purata $228 untuk pekerjaan ini

peterredei

This is not a bid. In your shoes I would first check the size of the data file(s). Detach the database, burn the data file(s) to DVD(s), mail the DVD to the hosting company and ask them to copy it from the DVD to the h Lagi

$1000 USD dalam sehari
(21 Ulasan)
5.8
vhrios

I'm a SQL Server expert! We can discuss the better solution together. Thanks in advance!

$250 USD dalam 5 hari
(1 Ulasan)
2.6
luckyfred

Hi, I have a lot DBA/SQL BI experience with Microsoft qualified award. I can help do this. Normally, if we could use data replication/read only way to do migration via VPN. If these 2 providers would haven't thi Lagi

$250 USD dalam 5 hari
(1 Ulasan)
1.8
vivekrnema

I have a long experience handling RDBMSs.

$250 USD dalam 7 hari
(0 Ulasan)
0.0
Caronettech

Hi I am ready to work on this project. Please provide me Thanks

$200 USD dalam 5 hari
(0 Ulasan)
0.0
ultrasonicsoft

I am good in SQL Server. I can help you out.

$250 USD dalam 10 hari
(0 Ulasan)
1.0
rudolfkuczi

Dear Sir, I've been using MS-SQL since version 2000. I'm also familiar with similar sized databases. By following my instructions you can minimize downtime required. Sent some brief details concerning my plan by PM.

$170 USD dalam sehari
(0 Ulasan)
0.0