Exporting large amounts of data from NAV 2015 - easy way?

nav13

I need to export the routing line data out of nav 2015 either using packages (which takes forever) or excel - apprx. 500,000+ records. Is there an easy way to complete this without spending days?

Thanks,
NAV13

Wisa123

If you need to do that export multiple times -> create a simple XMLPort.
If its a one-time thing ->just export as csv from SQL Management Studio.

At least that's what i would try/do.

RockWithNAV

Exporting Data from SQL is much easier and fast as compared to Rapidshare or XMLPort, I will suggest export from SQL.

Even if you dont want to export via opening Management Studio you can directly do this via Excel -

1. Open Excel.
2. Navigate to Data Tab.
3. Press from Other Sources --> First Option.
4. Enter the Credential Information and follow the Process.
5. You are done with good Output.

Enjoy.

kriki

Depends also what you need to do with it.

If something that can read Odata needs it, you can create a page and publish that as a Odata page.

You can also use bcp.exe from SQL server. It is for bulk import/export and because of that very fast.

EvR

The easiest way:
https://msdn.microsoft.com/en-us/library/dn495318(v=nav.90).aspx