Upgrading Sql From 2005 To 2008

• MuhammadShafiq

  SSCrazy

  Points: 2509

  More actions

  May 28, 2012 at 7:47 am

  #256601

  I have my complete database in sqlserver2005. All Is running well.There are a lot of Stored Procedures,Functions and Views etc etc.

  Due to some Business Requirements,my client want to migrate it to 2008.

  Now i have two questions

  i - what will be the best option for me to migrate to Sql2008 OR 2010 OR 2012.?

  ii - What steps should i follow? Is there any interface/Software/Script or o should do it manually?

  Regards

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  May 28, 2012 at 8:05 am

  #1493804

  Like all SQL questions the answer is "It depends". I suggest you do a Google search on "sql server upgrade advisor". Download the available software, run it .... and proceed from that point on.

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• MuhammadShafiq

  SSCrazy

  Points: 2509

  More actions

  May 28, 2012 at 8:15 am

  #1493811

  My host Provider have to upgrade it for me.They have 2008 and above.

  My question was as a developer what changes should i made to my script?should i change tables,SP's etc or Not.?

  Or should i simply import and export?