I am planning to migrate sql server 2000 databases to sql server 2005(sql server 2005 in a separate box) .I have few questions regarding the migration:
1. Do I have to run Upgrade wizard on 2000 even though I am not upgrading my sql server?
2.Which other databases do I need to move in addition to the user databases. (i.e. do i have to move any system databases?).
3. What do I need to do to move sql server logins with the password to the new machine?
Thanks.
Ks
YOu don′t run the Wizard on 2005, you can run the Upgrade Advisory wizard in SQL Server 2000. If you just want to migrate the user databases you can only migrate those. There is no need to move over additional databases.For more information about migrating users, take a look at Google, perhaps this links which provides the way to do this:
http://groups.google.de/group/microsoft.public.sqlserver.server/browse_frm/thread/d86b49a5fb086861/d936b4da230b7b05?lnk=st&q=logins+migrate+SQL+Server+2005+2000&rnum=4&hl=de#d936b4da230b7b05
http://groups.google.de/group/microsoft.public.sqlserver.setup/browse_frm/thread/a30917d64f6b9d24/f875221d21c8f71f?lnk=st&q=logins+migrate+SQL+Server+2005+2000&rnum=5&hl=de#f875221d21c8f71f
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment