I have an Acumatica partner that I do some customizations for. After doing a customization, they want me to do some data clean up because there are fields in a custom table that need to be back filled and it would be WAY easier for me to update my custom tables in SQL Query Analyzer. I could write "one time” scripts and put them in a customization project, but without visibility to see if the script did what I wanted, and without access to be able to query the tables, it is a mind numbing exercise to have the partner run the script in the project, create an extract and send it to me. I’m sure you know what I am talking about here.
I have my own databases hosted on Azure for my primary business and I can connect to them from my local PC, but the setup necessary to do that is not easy and requires some firewall changes and setting up Active Directory accounts.
So, is there any way I can get access to run queries on SQL databases hosted at Acumatica, the cloud etc.? If anyone has done this, I’d appreciate any advice. I know this is a vague question and I am not asking for specific details, but it would be great to know if anyone has even done it.
Thanks,
Joe
Best answer by eudescoelho29
View original