SQL server 2005 migration

• pdiwadkar

  SSC Veteran

  Points: 237

  More actions

  April 24, 2008 at 6:23 am

  #380148

  hi,

  We have machine where SQL 2005 server is installed.Atleast 3 web applications are running on it with data size 22GB in all. We need to migrate all data/tables/groups/users from this server to another server.On target server, SQL server 2005 will be installed.After that this migration activity needs to be carried out.what are options available to migrate to target server?

  Microsoft migration tool? Any already existing stored procedure etc?which is preferred solution in such case?

  Thanks for help

  PD

• Jayakumar Krishnan

  SSCarpal Tunnel

  Points: 4710

  More actions

  April 24, 2008 at 10:33 am

  #806727

  Hi,

  If you check in the following link the "Side by Side Upgrade" upgrade will help you well.

  http://www.sqlservercentral.com/articles/Administration/2987/

  and also other links to verify

  http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1194265,00.html

  http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

  Good luck.

  Have a great day...

  Jay.

  Thanks
  Jay
  http://www.sqldbops.com