Skip to main content

Notifications

Announcements

Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / synchronize table diff...
Microsoft Dynamics AX (Archived)

synchronize table different axapta and sql server

(1) ShareShare
ReportReport
Posted on by murtafiah 497

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

*This post is locked for comments

  • murtafiah Profile Picture
    murtafiah 497 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
    Sohaib Cheema Profile Picture
    Sohaib Cheema 46,614 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 497 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?

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,614 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics AX (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 100 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 48

#3
Zain Mehmood Profile Picture

Zain Mehmood 6 Moderator

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans