Microsoft Dynamics NAV (Archived)

importing and exporting data in Microsoft Dynamics Navision 2013

(0) Share

Report

Posted on by Community Member

Hi Team,

I followed this link to export and import data in Microsoft Dynamics Navision 2013.

https://blogs.msdn.microsoft.com/nav/2014/06/19/importing-and-exporting-data-in-microsoft-dynamics-nav-2013-r2-cu-8/

But I find a big issue.

When I try to import a 110MB data to an existing database, the original database size is 22GB, after finished, the database file size increased to 59GB.(No include log file size).

Then I did a second test, I tried to import an 25GB data to an existing database, the original database size is 22GB, I only finished 32%, and the database file size increased to 320GB. So I have to cancel the importing process.

What I missed? Why it processed so slow and eat so much disk capacity?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

Do you have recovery model = full in your database? If so, the log is growing because it logs every transaction.

However, if you perform a full backup, then the log is shrinked and must return to the size set by the administrator.

Was this reply helpful? Yes No
Rashed 3,765 on at

Like (0)

Report

data in a file does not mean it will be equal data in a database. A database creates indexes and they take a lot of space. the data in the file is zipped and data in a database is not.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No, I have tried to set the recovery model to simple and bulk-logged model, but it is same.

And the size I means is the .ndf file.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yesterday, I tired to import the 25GB .navdata file again, the .ndf file increased to 630GB, and only finished 51%. I think the file size is too big to accept. There should have some reason.

Was this reply helpful? Yes No