Navision native db - SQL Server Option

Comments

• rictsang Member Posts: 8

  2003-03-03

  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

  0
• andy76 Member Posts: 616

  2010-03-02

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

  0
• Waldo Member Posts: 3,412

  2010-03-02

  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?

  
  Eric Wauters
  MVP - Microsoft Dynamics NAV
  My blog
  

  0
• David_Singleton Member Posts: 5,479

  2010-03-02

  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!

  David Singleton
  

  0
• andy76 Member Posts: 616

  2010-03-02

  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

  0
• Waldo Member Posts: 3,412

  2010-03-02

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

  
  Eric Wauters
  MVP - Microsoft Dynamics NAV
  My blog
  

  0
• David_Singleton Member Posts: 5,479

  2010-03-02

  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
  

  0
• David_Singleton Member Posts: 5,479

  2010-03-02

  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
  

  0
• David_Singleton Member Posts: 5,479

  2010-03-02

  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.

  David Singleton
  

  0
• andy76 Member Posts: 616

  2010-03-03

  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

  0
• Waldo Member Posts: 3,412

  2010-03-03

  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.

  
  Eric Wauters
  MVP - Microsoft Dynamics NAV
  My blog
  

  0
• David_Singleton Member Posts: 5,479

  2010-03-03

  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.

  David Singleton
  

  0