Navision 3.70 in SQL 2005???

elwin68

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.

ara3n

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

nunomaia

SQL Server 2005 only works correctly with Navision client 4.0 SP3.
You must at least upgrade Navision client.

Waldo

SQL2005 is supported from 4.00SP1, but indeed, you should go for 4.00SP3.

David_Singleton

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.

Waldo

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).

David_Singleton

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.

nunomaia

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

Waldo

Don't know of any live setup. I don't talk about this option to my customers.

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

Marije_Brummel

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).

David_Singleton

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.

kriki

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?

kine

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: ).