Hi
i have a requirement to append a custom field value in a custom entity to another field within the same entity.
the records are in thousands and i cannot run this using api. given i am only updating custom field of a custom entity
that too within same entity: is it ok to run a weekly over night schedule task to do this in SQL code?
any help is appreciated.
*This post is locked for comments
Hi Likki ,
Doing any operation directly in CRM Database is not a good practice , so I would prefer to build console and using pagination retrieve more than 5000 records .
You can check below reference how to retrieve more than 5k records .
Hi Gautam
the entity has 55000 items and would like to do with SQL stored procedure. any implications if i choose this path?
Hi Likki ,
Please refer below old thread where I have shared how to write console and schedule the job in windows scheduler.
community.dynamics.com/.../273478
Hope this helps.
hi Adrian could you tell about console application way to achieve this? I am thinking a console application to open SQL connection and execute a stored procedure? is this what you mean by console app?
any help is much appreciated.
Hi Likki,
You can do it, but consider SQL Server Integration Services (SSIS), Workflows, and C# Console Applications as alternative options.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (