Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-05-14 : 01:58:44
|
| Hi,We are in urge for migrating sql 2000 to sql 2008.On what basis we can make a choice between In-Place Upgrade and Side-By-Side Upgrade?I personally felt that side-by-side is the best way to do the migration rather ending up in re-installing the sql server in doing a IN-PLACE upgrade.Would like to know which method does microsoft suggests/recommends and what factors we need to consider for going either of the methods.Thanks in Advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2010-05-14 : 02:21:04
|
| Hi Tara,Am unable to access the first URL. Am getting the below Error.The page is unavailable or no longer existsThe page you're trying to find is either temporarily unavailable or no longer existsAlso, i couldn't find any relating SIDE-BY-SIDE in the 2nd one.Can you kindly provide me the correct links.Thank You. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2010-05-14 : 02:46:58
|
| Hi,Oh okay!Can you suggest me a link which supports the argument from microsoft or if any.Thanks. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-14 : 03:58:56
|
| In-Place means migrating all databases on the server in one go. Very hard to restore back isn't it? (unless you have a whole-machine backup I suppose, but that is probably going to be slow to restore? That's fine if you have a maintenance window of a whole weekend I suppose, we have to cut over our databases in minutes, rather than hours, as they are used 24/7 ...)I've only ever done a SQL Server version upgrade using a new machine. We use the new machine for testing and then when we are ready we transfer a database from Old server to New server and put that live. We can transfer each database at a time to suit us - we don't have to do them all at the same time (which is sometimes critical if there are 3rd party apps involved which aren't ready for migrating yet) |
|
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
|
|
|
|
|
InPlace vs Side by Side