web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... CRM ID generation - Be...

Microsoft Dynamics 365 | Integration, Dataverse...

Answered

CRM ID generation - Best Practice

(0) Share

Report

Report

Posted on by Sam K

5

Hi,

I'm trying to load the large data set(300GB) into D365 out of box and custom entities using a 3rd party tool from a SQL Server database. CRM IDs are pre-generated using NEWSEQUENTIALID() function in the SQL Server DB.

Any disadvantage or performance impact on loading D365 with pre-generated CRM IDs?

Thanks.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

Hello,

Generally speaking, CRM uses a similar approach when it generates ids for records so your approach looks correct.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

Martin Dráb 47 Most Valuable Professional

#2

André Arnaud de Cal... 38 Super User 2025 Season 2

#3

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans