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-03-08 : 02:23:11
|
| Hi,Is that necessary/mandatory to install sp4 on sql server 2000 before going Sql 2008 migration with sp1?why am asking this is, we already have sp3 on sql 2000 enterprise edition instance and we now planning for sql 2008 migration. Since latest service pack available for sql 2000 is sp4, do we need to apply it first and then go for sql migration or can we directly migrate the sql 2000 sp3 instance to sql 2008 sp1 instance.Any Technical reasons?? In what way can i confirm to do sp4 install and then only migrate to sql 2008. What all things does this sp4 will fix if we install this before migration???Thanks in Advance. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-08 : 11:41:46
|
| if you're going to sql 2008, no need to apply sp4 |
 |
|
|
|
|
|
Service pack