Advantage or disadv of using Sql DB over Navision DB

wolftech

Hi

Can some one say me what is advantage or disadvantage of using SQL database over Navision Native Database.

Thanks in Advance

matttrax

1) The native database will not be supported in future versions of the product
2) While the native database used to be faster at calculating FlowFields it is no longer the case. As far as I know SQL outperforms Native in pretty much every area
3) SQL costs a lot of money. It's east to go into to $10k+ range with only SQL Server Standard

KYDutchie

Hi,

Also with SQL it is way easier to implement a good back up strategy. It is more flexible than the native backup.

Regards,

Willy

Savatage

Native DB is more self-sustaining, doesn't need performance tweaking and doesn't need to be monitored as much as SQL
Native also has a database size limit which SQl does not.

kriki

-Hardware requirements for the SQL server are a lot higher.
-Easier to connect SQL with other packets.

There is a lot of pro and contro for both DB's.
But I think this should be the winning factor:

matttrax wrote:

1) The native database will not be supported in future versions of the product

So for new installations, I would always go with SQL server.