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 |
|
koushikchandra
Starting Member
24 Posts |
 Posted - 2010-12-10 : 05:28:23
|
| Hi,Can some one please help me out with the steps of migration of SQLServer 2000 to 2008 version. I haven't done any SQLServer migration before so I want the steps in details. Also please let me know what will be the impact on SSIS packages for this.Regards,Koushik Chandra |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-10 : 05:36:26
|
| Think you will end up with a schema created for each user if you just do a backup restore.When did the resultset stop being ordered by the group by columns - was that before v2000?Anything accessing system tables should be reviewed.I would test and redeploy all ssis packages as there will be later versions of classes probably.Theres a good chance there won't be many issues.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-11 : 03:07:59
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230Doesn't cover DTS / SSIS though |
|
|
|
|
|
|
SQLServer migration from 2000 to 2008