Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 4 of 4

Thread: Ml 8.0.1.2 & mssql 2008

  1. #1
    tmoney101 is offline Senior Member
    Join Date
    Oct 2007
    Posts
    152

    Default Ml 8.0.1.2 & mssql 2008

    We have a site running ML 8.0.1.2 with MSSQL 2005. We just wanted to double check there will be no issue upgrading the database to the 2008 version? If anyone has done this or could confirm there would be no issues that would be great.

  2. #2
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    We have upgraded our 8.0.1.2 on SQL2005 to v9.2 on SQL2005 and then the 9.2 from SQL2005 to SQL2008 without any problems. The secret is in the repetitive testing and scripting until you know you can do it time and time again!
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!

  3. #3
    mikester is offline Junior Member
    Join Date
    Jun 2007
    Posts
    5

    Default

    does the 8.0.1.2 to 9.0 SQL Script have to be run in 2005 or can it be run in 2008 before upgrading from 9.0 to latest?

    I ran the script without error on 2008 but wondering if I need to go back and do it on 2005 for part 1 and 2008 for part 2.

  4. #4
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    Depends what you are trying to achieve. You can either upgrade the db app from v8 to v9 in SQL2005 first and then upgrade 2005 to 2008. Or you can move the v8 db app from 2005 to 2008 and then upgrade from v8 to v9. Doesn't matter.

    Best thing is to have a plan. And test.
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!