Hi all,
today I just want to share with you solution how to import demo AX 2012 R3 demo data without need to install transfer tool on your SQL machine.
After I read some guides and still getting access denied or other errors, due to run tool from AOS, I realized that I will need to try solution with tool installed on the SQL. But this is not really good idea when you have all DEV DBs on it and in use... Nobody wants to mess with the SQL server in rush hours. So...
Solution is pretty simple. You still need to run the tool from the SQL machine, but by this steps you can install tool and data on AOS server (look for classic guides on web) and when you are ready to import data do this:
- logon to SQL machine
- open File Explorer and to address row just put (connect to server with tool and data)
\\Your_Server_With_Tool_name\Disk_Drive_With_Tool$\DP_Tool_Folder
EXAMPLE: \\AX2012R3CU10\D$\TranferTool\
- then run CMD from File Explorer menu As Admin
- CMD will run with drive letter as connected drive (Z, Y, or something)
- then just use
dp.exe IMPORT \\Your_Server_With_Tool_name\Disk_Drive_With_Tool$\FolderWithDemoData DB_Name
Import will be succesful (maybe with some errors) without need to install Test Data Transfer Tool on the SQL Server machine.
Hope this help you.
Marek
