Database size increase with migration to SQL?

steelman

Hello,

We are planning to migrate our database to SQL server soon, and I would like to know if there will be any size increase of the database? I am quite new to the company and navision itself, I know that SQL has log files which can get quite sizable, but I am not sure how these compare to the nav native logs (if they exist at all).

Any help?

Thanks.

kriki

These are the formula's I use to calculate the size of the SQL files:

-NAV until 5.0 (no SP) no SQL optimizations: DB = 2.5 times the native size
-NAV until 5.0 (no SP) with SQL optimizations: DB = variable. In a heavy optimized DB can be smaller than native size
-NAV from 5.0SP1 : 1 to 1.5 times native size

-transactionlog (best put in simple recovery mode): the size of the DB in SQL. (afterwards it can be truncated if needed. But it is best to keep the size for the rebuildindex maintenance).

steelman

thank you

stryk

Maybe this could further help you with your migration project: http://dynamicsuser.net/blogs/stryk/archive/2009/12/09/the-nav-sql-performance-field-guide.aspx