InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 13:59:40 GMT20http://www.sqlservercentral.com/Forums/Topic769884-1451-1.aspxnot quite that advanced, visio 2003!Wed, 19 Aug 2009 00:31:12 GMTedwardelliotthttp://www.sqlservercentral.com/Forums/Topic769884-1451-1.aspxThe process diagram looks very nice. May I know you are using which tool ? Is it vision 2007?:-)Wed, 19 Aug 2009 00:13:46 GMTrockniuhttp://www.sqlservercentral.com/Forums/Topic769884-1451-1.aspxHi,Thanks for the comments!greggoble2 - your right using the transfer logins task can definitely help here.tushkieeeee - unfortunately you can't mirror a sql 2000 instance, you can go from 2005 to 2008 though.edTue, 18 Aug 2009 05:08:08 GMTedwardelliotthttp://www.sqlservercentral.com/Forums/Topic769884-1451-1.aspxVery nice way to tackle the issue of hardware replacement !Tue, 18 Aug 2009 03:44:54 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic769884-1451-1.aspxAwesome article. I have to migrate a replication databases on 2000 servers to 2008 servers. Will it be possible in this case too?Mon, 17 Aug 2009 19:39:46 GMTtushkieeeeehttp://www.sqlservercentral.com/Forums/Topic769884-1451-1.aspxBrilliant article on a good technique. I am going to have to try this out before I actually need it.Mon, 17 Aug 2009 18:17:43 GMTtimothyawisemanhttp://www.sqlservercentral.com/Forums/Topic769884-1451-1.aspxJust a suggestion on step 3 i've found that using the transfer login task and setting copy sid's = TRUE is easier if you have multiple logins to copy.Mon, 17 Aug 2009 10:35:04 GMTggoblehttp://www.sqlservercentral.com/Forums/Topic769884-1451-1.aspxHi Mark, The process is pretty straight forward.The thing that really helped was getting backups restored on the new server and getting a test copy of the site working with that to make sure all the users were in place with the correct passwords etc. It certainly meant I was more confident when it came to failing the databases over.edMon, 17 Aug 2009 05:04:01 GMTedwardelliotthttp://www.sqlservercentral.com/Forums/Topic769884-1451-1.aspxPretty interesting approach! This seems like it would work smoothly. Did you run into any snags along the way?Mon, 17 Aug 2009 04:27:24 GMTSuperDBA-207096http://www.sqlservercentral.com/Forums/Topic769884-1451-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Mirroring/66357/">Ten steps to migrate databases between servers in a .Net environment</A>[/B]Wed, 12 Aug 2009 23:53:35 GMTedwardelliott