Synchronize database (form)
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Click System administration > Periodic > Database > SQL administration. On the Table actions menu, click Synchronize database, or click Check/Synchronize.
–or–
Initialization checklist > Synchronize database
When you select Synchronize database, the effect of all changes to tables and indexes that you have selected are analyzed and then applied to the database. The Synchronize database form provides information about the effect that the synchronization process will have.
Tasks that use this form
Navigating the form
The following table provides descriptions for the controls in this form.
Tabs
Tab |
Description |
|---|---|
Overview |
Displays a summary of the errors and warnings that will be encountered during synchronization. |
Errors |
Lists errors that will be encountered during the synchronization process. |
Warnings |
Lists warnings that will be encountered during the synchronization process. |
Buttons
Button |
Description |
|---|---|
Print the list of errors and warnings. |
|
Export script |
Export the data definition language (DDL) statements that will be executed during the synchronization process to a script. To help speed processing, for example, to run scripts in parallel, you can run exported DDL scripts from outside Microsoft Dynamics AX. However, when you run scripts in parallel from outside Microsoft Dynamics AX, you may encounter dependency issues and errors. Microsoft cannot assume responsibility for issues encountered if you decide to run DDL scripts outside the client. We strongly recommend that if you are going to run an exported script that you first create a backup of the database. |
Continue |
Continue the synchronization process. |
Cancel |
Cancel the synchronization process. |
Fields
Field |
Description |
|---|---|
TableName |
Lists any tables that will encounter errors or warnings during the synchronization process. |
Text |
Lists the text of errors and warnings. |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).