Skip to main content
Answer

Can we import the table data from SQL DB file through Acumatica screen

  • November 2, 2020
  • 2 replies
  • 335 views

Naveen Boga
Captain II
Forum|alt.badge.img+19

Hello,

Can we import/dump the SQL table data from SQL DB backup file through the Acumatica screen. If yes, could you please me know how can we acheive this? 

 

Best Regards,

Naveen B

Best answer by vkumar

Hi Naveen,

You can setup SQL DB provider and use an import scenario to import the data from SQL db provider. 

Here is the help documentation link:

https://help-2020r2.acumatica.com/(W(5))/Help?ScreenId=ShowWiki&pageid=9770d5a6-6ea8-4187-9d1e-ca5a28249eb1

Hope this helps,

Regards,

2 replies

Forum|alt.badge.img+12
  • Acumatica Support Team
  • Answer
  • November 2, 2020

Hi Naveen,

You can setup SQL DB provider and use an import scenario to import the data from SQL db provider. 

Here is the help documentation link:

https://help-2020r2.acumatica.com/(W(5))/Help?ScreenId=ShowWiki&pageid=9770d5a6-6ea8-4187-9d1e-ca5a28249eb1

Hope this helps,

Regards,


Forum|alt.badge.img+1

Hi @Naveen Boga @vkumar  I am not able open my db I got  below error could you plz have a look

Thanks

shahidavali