February 10, 2012 at 12:12 pm
We need to move a database for a big applicaiton to a single SQL server from a shared SQL server because of this database really use a lot of resources. The current server is SQL server 2008, our plan is to migrate to a new server that also install SQL 2008.
Because if we keep the same version, it will reduce a variable that could make the migration fail.
But I also think to install SQL 2008 R2, we do have license. But this add another variable the migration may fail. We also have some ssis packages that developed from 2008. if migrate to R2, will that still work on 2008 R2 SSIS?
What do you recommend?
We have a tight timeline to move the database to the new server.
Thanks
February 10, 2012 at 1:28 pm
Get a dev environment setup and try it out. There shouldn't be any issue but it is impossible to say that for sure. The ONLY way you can be sure it will work is to test, test, test. Then test it one more time, do your migration and be in a situation where you can quickly deal with the issues that do arise. As with any migration MAKE SURE YOU HAVE A ROLLBACK PLAN!!!!!!!! That way when something goes horribly wrong that you couldn't have predicted and you just can't get it working you can quickly and easily go back. You should test your rollback procedure too.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 10, 2012 at 1:33 pm
if we migrate to R2, do we need to have SQL server R2 developer edition in order to develop SSIS?
Will 2008 version SSIS package still work on R2 SSIS?
Thanks
February 11, 2012 at 3:28 am
sqlfriends (2/10/2012)
Will 2008 version SSIS package still work on R2 SSIS?Thanks
Depends on what the package is doing! If its a basic package with no special features then probably yes. You will need to test this and ideally open up the package to get an idea of what it does\requires
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply