June 17, 2009 at 5:43 am
Has anyone made the leap from SQL Server 2000 to SQL Server 2008 and if so where you able to retain all users, logins, db's, packages and other objects in tact and ready to roll, after the upgrade? And if not what did you have to do to get everything working properly?
June 18, 2009 at 2:04 am
Yes, it is possible, and you can keep the User Accounts etc.
The Tools here help alot:
http://support.microsoft.com/kb/246133
And a script to generate server logins, roles, permissions, users etc can be found in this thread here:
http://www.sqlservercentral.com/Forums/FindPost711892.aspx
(note i have only used this in a 2005(32bit)-2008(64bit) upgrade, but combined with the MS article, getting it to work 2000-2008 should not be a problem)
As for packages, they may well need some more manual work, DTS etc... (again, more info in the above thread)
J.
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply