web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Data Base Tables Synch...
Microsoft Dynamics AX (Archived)

Data Base Tables Synchronize from SQL,

(0) ShareShare
ReportReport
Posted on by Community Member

I have some requirement to Synchronised DataBase's table through SQL.

through AX we do it Normally like "AOT > DataDictionary> right click and Sync"

Apart from this any other Option, "like from SQl in view of technical?"

Is it Possible in SQL, 
is there any query there to write

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Pir_Rana Profile Picture
    Pir_Rana 836 on at

    Hi,

    Other then this you can synchronize database from:

    System administration > Periodic > Database > Sql Administration form.

    On header tab go to  Table action and synchronize.

  • Suggested answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at

    Hi

    Take a look at blogs.msdn.com/.../ddl-script-generator-for-dynamics-ax-2012-r2.aspx

    Practically, you can run the Sync through  SQL Management studio

    Hope this help you

  • Community Member Profile Picture
    Community Member on at

    HI Mohammad and Denis

    I mean to say through SQL, I knew Above Two steps, one is through AOT and System Admin Module,

    here I have two Data Base

    > One is AX Data Base,

    > One is  MDM DataBase and MDM DataBase is Not attached with AX, it is only Visible in SQL Studio.(in SQL in want to Sync Tables)

  • Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at

    Hi Gopal

    Can you elaborate better ?

    If you go through the link above, you are able to generate sql scripts and run through SQL Management Studio.

  • Community Member Profile Picture
    Community Member on at

    dose the above link Solve my issuse?

  • Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at

    YES!

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans