i’m working on ax project now. i want to move all databases from existing server to a new server. I tried to move the mdf file(using attach database option in sql server), but not all data is moved after ax compile and synchronize the table. after that i restore the database with a .bak file from the old server, but it gives error code 100.
You haven’t told us what exactly are the issues that you are facing. So what issues do you face when you move data? Also what data are you looking to move?
Remember that whenever you move DAX database from one environment to another, the underlying DAX code base (such as layer, label files etc) has to be identical.
If you are just looking to move master data, one option is to use AX standard functionality to export and import.