Need to Export / Import approx. 1Million records

vivek4121

Hi All,

I have to export a table data which contains approx. 1 Million records and need to be imported into another table (in other database) in NAV.

Is there any quick way to achieve it apart from creating XML Port.

As rapid start is not working in this case getting below issue:

Microsoft Dynamics NAV
---------------------------

SaveCopyAs method of Workbook class failed
---------------------------
OK
---------------------------

Thanks in advance

RockWithNAV

If it's just a replica table then with no any codes on validation and all then do it from SQL.

David_Singleton

RockWithNAV wrote: »

If it's just a replica table then with no any codes on validation and all then do it from SQL.

I agree, in fact I wouldn't do it any other way.

Slawek_Guzek

Export:

bcp [src_database].dbo.[src_table] format nul -S src_server_name -T -c -x -f format_file.xml
bcp [src_database].dbo.[src_table] out data.dat -S src_server_name -T -c -f format_file.xml

Import:

bcp [dest_database].dbo.[dest_table] in data.dat -E -S dest_server_name -T -f format_file.xml

EvR

If the table definition is the same, you don't need any additional validations and you are sure there are no existing records (PKs) that can collide, then push it directly in SQL. Saves you so much time.