Post reply

Upgrading Sql From 2005 To 2008

  • 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

  • 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]

  • 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?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply