SQL ver 8.00.194 migrate to sql 2005/2008 32 bit

bsfartiyal
bsfartiyal Member Posts: 110
edited 2013-01-04 in SQL General
it is possible to migrate SQL ver 8.00.194 database direct to SQL 2005 of SQL 2008 32 bit version?

SQL ver 8.00.194 support to windows 2008 32 bit ?

help?

regards

BS

Comments

  • ara3n
    ara3n Member Posts: 9,258
    I suggest to do a NAV backup and restore.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • bbrown
    bbrown Member Posts: 3,268
    If you're going thru the effort, why not move to 64 bit SQL while you're at it?
    There are no bugs - only undocumented features.
  • bsfartiyal
    bsfartiyal Member Posts: 110
    bbrown wrote:
    If you're going thru the effort, why not move to 64 bit SQL while you're at it?

    Navision 4.0 SP3 not support to 64 BIT, so its required only 32 BIT Software.

    I trying to migrate SQL 8.00.194 to SQL 2005 , so it is possible ?
  • bbrown
    bbrown Member Posts: 3,268
    bsfartiyal wrote:
    ...Navision 4.0 SP3 not support to 64 BIT...


    Where'd you hear that?
    There are no bugs - only undocumented features.
  • bsfartiyal
    bsfartiyal Member Posts: 110
    bbrown wrote:
    bsfartiyal wrote:
    ...Navision 4.0 SP3 not support to 64 BIT...


    Where'd you hear that?

    client not support
  • bbrown
    bbrown Member Posts: 3,268
    Do you mean the NAV client or your customer doesn't support. (The NAV client doesn't know the difference and therefore doesn't care)
    There are no bugs - only undocumented features.
  • bsfartiyal
    bsfartiyal Member Posts: 110
    bbrown wrote:
    Do you mean the NAV client or your customer doesn't support. (The NAV client doesn't know the difference and therefore doesn't care)

    I have install nav 4.0 sp3 on a 64 bit operating system with sql 2008 but Nav server is running and connect through client it giving error, Client is not support to operating system.

    if connect through client with 32 bit OS its working file.
  • bbrown
    bbrown Member Posts: 3,268
    What build of NAV 4.0 SP3 are you using?

    What are you getting for an error?

    What do you mean by "Client is not support to operating system"?

    NAV works just fine with 64 bit SQL. In fact, it's highly recommended over 32 bit.
    There are no bugs - only undocumented features.
  • bsfartiyal
    bsfartiyal Member Posts: 110
    bbrown wrote:
    What build of NAV 4.0 SP3 are you using?

    What are you getting for an error?

    What do you mean by "Client is not support to operating system"?

    NAV works just fine with 64 bit SQL. In fact, it's highly recommended over 32 bit.

    SQL 64 bit ok but 64 bit OS ???????
  • bbrown
    bbrown Member Posts: 3,268
    Both are fine. (You can't run 64 bit SQL without a 64 bit OS)
    There are no bugs - only undocumented features.
  • bsfartiyal
    bsfartiyal Member Posts: 110
    bbrown wrote:
    Both are fine. (You can't run 64 bit SQL without a 64 bit OS)

    I lot of time try to run NAV 4.0 sp3 client in windows 64 bit OS but not running.

    is NAV 4.0 sp3 client is available in 64 bit ??

    Regards

    B.S.Fartiyal
  • bbrown
    bbrown Member Posts: 3,268
    NAV is a 32 bit client. But it will run in a 64 bit OS.

    What sort of problems do you have?
    There are no bugs - only undocumented features.
  • bsfartiyal
    bsfartiyal Member Posts: 110
    bbrown wrote:
    NAV is a 32 bit client. But it will run in a 64 bit OS.

    What sort of problems do you have?

    Actually my one customer have 64 bit OS and SQL 64 bit also, but NAV 4.0 SP3 client not support, only we can install server, but when client run in server it not running.

    if we connect through other machine with 32 bit its working.
  • bbrown
    bbrown Member Posts: 3,268
    Can you be more specific about the problems or errors you encounter. We might be able to help you. I support lots of systems running NAV on 64 bit OS

    BTW - NAV 4.x is no longer support at all. But, when it was supported, it was supported with 64 bit SQL.
    There are no bugs - only undocumented features.
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    bsfartiyal wrote:
    bbrown wrote:
    If you're going thru the effort, why not move to 64 bit SQL while you're at it?

    Navision 4.0 SP3 not support to 64 BIT, so its required only 32 BIT Software.

    I trying to migrate SQL 8.00.194 to SQL 2005 , so it is possible ?

    This statement is false.

    We have clients running 4.0 with 64 bit SQL right now without any problems. There is something special going on on your machine that's preventing you from running 4.0 client on the 64 bit machine. Your question is probably better answered on a Windows forum.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

Categories