Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

synchronize table different axapta and sql server

Posted on by 495

Morning All,

i have a problem, why one table nothing in sql server?

example table with name : PurchAgreementHeader.

If you have a solution please call me.

Thanks,

Fiah

Categories:
  • murtafiah Profile Picture
    murtafiah 495 on at
    RE: synchronize table different axapta and sql server

    Dear Mr. Sohaid,

    Yes you're right, i was understanding.

    Thanks for at the solution.

    Thanks,

    Fiah

  • Verified answer
    sohaibcheema Profile Picture
    sohaibcheema 46,592 User Group Leader on at
    RE: synchronize table different axapta and sql server

    get fields from tables AgreementHeader. all fields of PurchAgreementHeader will be available in AgreementHeader table.

    In addition you may be interested to read about table inheritance

    a blog post by Martin

    dev.goshoom.net/.../queries-to-tables-with-inheritance

    and then msdn

    msdn.microsoft.com/.../gg881053.aspx

  • murtafiah Profile Picture
    murtafiah 495 on at
    RE: synchronize table different axapta and sql server

    and then what should i do if i want PurchAgreementHeader show in DB of sql server?

  • sohaibcheema Profile Picture
    sohaibcheema 46,592 User Group Leader on at
    RE: synchronize table different axapta and sql server

    Because this table(PurchAgreementHeader) extends another table AgreementHeader

    So on Database you can always see Base Table.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans