Need to Export / Import approx. 1Million records

vivek4121
vivek4121 Member Posts: 165
in NAV Three Tier
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

Comments

  • RockWithNAV
    RockWithNAV Member Posts: 1,202
    If it's just a replica table then with no any codes on validation and all then do it from SQL.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • David_Singleton
    David_Singleton Member Posts: 5,479
    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. ;)
    David Singleton
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,692
    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


    Slawek Guzek - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;
  • EvR
    EvR Member Posts: 178
    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.

Categories