Friday, 5 June 2015

Import and Export a database and model


Import a database
  1. Go to Sql Server Management Studio/SSMS >> click connect for the user
  2. Right Click on databases and select Restore database.
  3. Select either from Device or Database.
  4. Ensure that AOS is stopped.
  5. Go to options (on the left side) select the check box over-write.
  6. click ok.
Export/Backup a databse
  1. Go to Sql Server Management Studio/SSMS >> click connect for the user.
  2. Expand the database and right click on either MicrosoftDynamicsAX/MicrosoftDynamicsAX_model (which ever you want to take export or take backup) and select Task >> back-up
  3. Select the destination path wherever required and ensure that the extension of the backup file is .bak 
  4. click ok.

No comments:

Post a Comment