mibuso.com
Home› SQL General
Options

Navision 3.70 in SQL 2005???

elwin68elwin68 Member Posts: 153
edited 2007-04-24 in SQL General
Our customer is working with Navision 3.70 in a native database.
He wants to upgrade the database to SQL.
This can be SQL 2000 and SQL 2005?

Now I have 2 questions.
- Is it possible to work with Navision 3.70 in SQL 2005?
- If yes, which version is preferred, SQL 2000 or SQL 2005?

Thanks in advance.

Answers

  • Options
    ara3nara3n Member Posts: 9,255
    3.7 runs only sql 2000.
    But. I wouldn't spent money on 7 year old software. Install navision 4.sp 3 client.and purchase sql 2k5
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    nunomaianunomaia Member Posts: 1,153
    SQL Server 2005 only works correctly with Navision client 4.0 SP3.
    You must at least upgrade Navision client.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Options
    WaldoWaldo Member Posts: 3,412
    SQL2005 is supported from 4.00SP1, but indeed, you should go for 4.00SP3.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    David_SingletonDavid_Singleton Member Posts: 5,479
    elwin wrote:
    Our customer is working with Navision 3.70 in a native database.
    He wants to upgrade the database to SQL.
    This can be SQL 2000 and SQL 2005?

    Now I have 2 questions.
    - Is it possible to work with Navision 3.70 in SQL 2005?
    - If yes, which version is preferred, SQL 2000 or SQL 2005?

    Thanks in advance.

    Is anyone actually running 3.70 on SQL 2005 in a live environment?

    I mean I know it works, and I have not seen any problems, BUT is it safe in a production environment.

    I know that upgrading is fine, but sometimes the cost can be so high as to just not be worth it.
    David Singleton
  • Options
    WaldoWaldo Member Posts: 3,412
    You can change the compatibility mode to SQL2000 ... I guess in that case, you can run 3.70 on a SQL2005 server (actually, you still have a 2000 database that way).

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    David_SingletonDavid_Singleton Member Posts: 5,479
    Waldo wrote:
    You can change the compatibility mode to SQL2000 ... I guess in that case, you can run 3.70 on a SQL2005 server (actually, you still have a 2000 database that way).

    That's what I am doing locally, and it works fine, but I am wondering if anyone is doing this in a live environment.
    David Singleton
  • Options
    nunomaianunomaia Member Posts: 1,153
    David Singleton wrote:
    Waldo wrote:
    You can change the compatibility mode to SQL2000 ... I guess in that case, you can run 3.70 on a SQL2005 server (actually, you still have a 2000 database that way).

    That's what I am doing locally, and it works fine, but I am wondering if anyone is doing this in a live environment.

    I think Microsoft doesn’t support that setup. :-k
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Options
    WaldoWaldo Member Posts: 3,412
    Don't know of any live setup. I don't talk about this option to my customers.

    I wouldn't recommend it ... [-X

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    David Singleton wrote:
    Is anyone actually running 3.70 on SQL 2005 in a live environment?

    I have at least one customer who insisted on doing this upgrade [4SP3 runtime on SQL2005] and it behaves strange somtimes. But this is mainly due tho THE bug. (See no. 2 post all times).

    We are working on eliminating the terrible reads on some of the tables and implementing all workarounds we know of. :?

    (I advised to move back to SQL 2000).
    Marije Brummel | Freelance Business Central Specialist
  • Options
    David_SingletonDavid_Singleton Member Posts: 5,479
    Mark Brummel wrote:
    David Singleton wrote:
    Is anyone actually running 3.70 on SQL 2005 in a live environment?

    I have at least one customer who insisted on doing this upgrade [4SP3 runtime on SQL2005] and it behaves strange somtimes. But this is mainly due tho THE bug. (See no. 2 post all times).

    We are working on eliminating the terrible reads on some of the tables and implementing all workarounds we know of. :?

    (I advised to move back to SQL 2000).

    Thanks Mark, thats what I wanted to know.
    David Singleton
  • Options
    krikikriki Member, Moderator Posts: 9,090
    Mark Brummel wrote:
    David Singleton wrote:
    Is anyone actually running 3.70 on SQL 2005 in a live environment?

    I have at least one customer who insisted on doing this upgrade [4SP3 runtime on SQL2005] and it behaves strange somtimes. But this is mainly due tho THE bug. (See no. 2 post all times).

    We are working on eliminating the terrible reads on some of the tables and implementing all workarounds we know of. :?

    (I advised to move back to SQL 2000).
    And Navision 5.00 has still this problem? Or is it solved?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Options
    kinekine Member Posts: 12,562
    I assume that no. Do not forget that NAV 5.0 is most optimized version for usage MS SQL 2005 from all versions (but it doesn't mean that there is no :bug: ).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.