Navision native db - SQL Server Option

Waldo

I know that SQL Server supports record level locking, Navision native db does not (table locking). Is it so that when we use the SQL Server option, the tablelocks will decrease, or will it be just te same as in the Navision Native db??

Is there some kind of paper the describes the differences (advantages and disadvantages) between SQL Server and Native db?

rictsang

you can find the document from NSC. They have explained the difference between Navision native database and SQL database, like security, database administration, advantage and disadvantage.

Richard

andy76

Hi,

What do you mean by NSC?
Where can I find this info?
Is there some link?

Thank you

Waldo

that's kind of a late reply

NSC = Navision SOlutions Center

I don't think there is a document available you're looking for. What exactly is your problem?

David_Singleton

Waldo wrote:

I know that SQL Server supports record level locking, Navision native db does not (table locking). Is it so that when we use the SQL Server option, the tablelocks will decrease, or will it be just te same as in the Navision Native db??

Is there some kind of paper the describes the differences (advantages and disadvantages) between SQL Server and Native db?

:shock: :shock: :shock:

You can read waldo's blog for lots of great information about this!

andy76

I am preparing a brief presentation power point to explain the differences and advantages of SQL Server to convince new project to start directly in SQL or to migrate to SQL.

Thank you

Waldo

David Singleton wrote:

Waldo wrote:

I know that SQL Server supports record level locking, Navision native db does not (table locking). Is it so that when we use the SQL Server option, the tablelocks will decrease, or will it be just te same as in the Navision Native db??

Is there some kind of paper the describes the differences (advantages and disadvantages) between SQL Server and Native db?

:shock: :shock: :shock:

You can read waldo's blog for lots of great information about this!

lol, that's true :-)

David_Singleton

Waldo wrote:

David Singleton wrote:

Waldo wrote:

I know that SQL Server supports record level locking, Navision native db does not (table locking). Is it so that when we use the SQL Server option, the tablelocks will decrease, or will it be just te same as in the Navision Native db??

Is there some kind of paper the describes the differences (advantages and disadvantages) between SQL Server and Native db?

:shock: :shock: :shock:

You can read waldo's blog for lots of great information about this!

lol, that's true :-)

I added the mr green after I saw the date on the original post. Blast from the past or what.

David_Singleton

andy76 wrote:

I am preparing a brief presentation power point to explain the differences and advantages of SQL Server to convince new project to start directly in SQL or to migrate to SQL.

Thank you

Here is an article I wrote many years back to do the exact same thing:

C/SIDE database vs SQL

back then it was a tough decision as to which to use. But for at least 3 years now the advantages of SQL far outweigh Native.

David_Singleton

David Singleton wrote:

andy76 wrote:

I am preparing a brief presentation power point to explain the differences and advantages of SQL Server to convince new project to start directly in SQL or to migrate to SQL.

Thank you

Here is an article I wrote many years back to do the exact same thing:

C/SIDE database vs SQL

back then it was a tough decision as to which to use. But for at least 3 years now the advantages of SQL far outweigh Native.

Oh and Andy you are free to use that article in your power point, so long as you credit where you got it from.

andy76

I read a lot of time ago that there are restrictions about database native regarding dimension and number of users that there are limits.
Where can I find these detailed informations about db dimension, RAM exploitation, CPU and so on?

Thank you very much

Waldo

If I'm not mistaken, you can find a lot in the Application Developmer's Guide (ADG) on the product CD.
You can explore the partnersource as well for hardware-stuff.
But again, a lot you can find on the forums. It's actually quite simple: native only supports 1 CPU and 1Gb RAM. That's it. Not really scalable for that matter.

David_Singleton

andy76 wrote:

I read a lot of time ago that there are restrictions about database native regarding dimension and number of users that there are limits.
Where can I find these detailed informations about db dimension, RAM exploitation, CPU and so on?

Thank you very much

It's quite simple, Microsoft have made a decision not to support two database servers, and obviously they are not going to drop SQL. Thus Microsoft have done no development at all on the Navision Native database, and even though at its peak, the Native database was one of the most technically advanced Databases out there, that was 15 years ago, and in reality nothing has changed since the DOS version. currently the only issues with Navision on SQL, are 1/ the added cost, 2/ some additional maintenance, 3/ the application is still in soe places optimized for the native database not SQL.