January 12, 2015 at 7:34 pm
We are migrating our database from SQL 2000 to SQL 2008 R2 - Testing phase right now but will be going live in a couple of weeks.
We are going to keep the database in SQL 2000 compatibility mode for the time being on SQL 2008 R2.
I made a backup of the database and copied it to the new location which is in AWS.
I now need to migrate only the changes that are taking place in the SQL 2000 database to the database on sql 2008 R2
I am thinking log shipping, but not sure if that will work between versions.
Anyone have any recommendation for moving only the changes to the new location?
When I do this for real I will only have a 2-3 hour window for this process.
It took over 20 hours to copy the zipped up database to the new location and that in not acceptable when we do this for real.
Thanks
Gary
January 13, 2015 at 1:46 am
Log shipping will work, you just have to have the destination DB RESTORING, standby isn't an option when there's a version mis-match.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2015 at 5:09 pm
Do you have any links you would be willing to offer up on the how to do this?
Thanks
Gary
January 14, 2015 at 1:18 am
Not offhand, but a quick google search for articles on setting up log shipping should return a few hundred results.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply