July 2, 2007 at 1:44 pm
Hello,
SQL Server 2005 Enterprise and new hardware have been ordered for our department. We currently run SQL Server 2000 (sp4). We have almost 500 DTS packages, 293 Jobs, and 14 user databases with hundreds of objects within.
Is there any documentation out there on how to scrutenize a current system? I have searched, and most of what I can find addresses migration planning with the assumption that the databases, packages, jobs, security, etc are ready to move over. We have a lot to think about before we can do that. We know we have redundancy problems (like View proliferation), table schema issues, obsolete DTS packages and Jobs, and otherwise a host of opportunities to 'clean house' and/or improve. We would really like to get a handle on what we are migrating before we migrate.
If you have any ideas or resources to you feel would be worth looking at, please share.
Thank you for your help!
CSDunn
July 2, 2007 at 2:56 pm
Sorry, I didn't intend to post this in the Security forum.
CSDunn
July 2, 2007 at 7:35 pm
Take a look at the SQL Server 2005 Upgrade Advisor: Microsoft Download Location.
K. Brian Kelley
@kbriankelley
July 4, 2007 at 2:00 am
For jobs script them and run against your 2005 server. For user DBs - detach and attach and change the mode to 90 to have full features of SQL 2005. Any logins there is a script that microsoft has given sp_help_revlogin that is available use that to script logins and recreate. Regarding DTS you should make a calll for yourself.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 4, 2007 at 6:23 am
In addition to what Sugesh said,jus fyi
http://support.microsoft.com/kb/918992 ---How to transfer logins and Pwds b/w instances of sql2005
http://support.microsoft.com/kb/224071 ---How to move sysdbs in sql 2000 and sql 2005
[font="Verdana"]- Deepak[/font]
July 5, 2007 at 8:10 am
Thanks!
CSDunn
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply