Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I need to move SysLastValue from one environment. to another.
Unfortunately, I can't move that via SQL, but I can read the source. It means, I can see a Hexadecimal value that is stored in DB.
The VALUE field that represents Container looks more or less like this:
How to transform this hex value in AX to be able to store that in SysLastValue.value field?
Could you tell us more about your business requirement, please? Which object is this SysLastValue record related to? What you're trying to do may be logically impossible, depending on details of your situation.
How did you get this hex string?
Before I posted that I tried to find an answer in the internet and I read couple of your posts about Binary and BinData.
Actually, I was hoping it would be you that could answer, because it looks like you are quite experienced in this area :)
I need to copy (from Test environment to Production) over 500 records of SysLastValue connected to specific user.
I accidentally cleaned his profile and I need to restore it back.
Luckily, we copied our DB (PROD->Test) this week, and the user is on vacation. Situation is not so bad :)
His Usage Data contains:
I took Raw Hexadecimal Strings directly form Test DB via SSMS.
If there is a way for some transformation, I planned to import them from CSV.
Converting the string to Binary should be doable, but let's consider another approach. Let's say you create the records without Value. This will assign RecIds, therefore we won't have to worry about them. And then you'll use SQL code to update Value. Like this:
SET Value = 0x07FD0104000000011C00000001A606000001DE02000001D2000000017100000001FFFFFFFFFF
As I understand, you can't connect to the database, but maybe you could execute SQL code from X++ (with Statement class).
Yes, it could be a good idea. I forgot about this way.
I have full records (not only hex strings), with original RecIds, so I would try to even use INSERT in the SQL statement.
It was a good idea. Sometimes a simplest way is the most optimal solution.
The only thing that is maybe worth to mention here is RunOn property.
SQL commands must be run on server, but of course AOS user couldn't read CSV file from my local folder. This is something for client. Those 2 functions should be separated then
When you need to read a file from a process running on AOS, the usual approach is putting it to a file share accessible from the server.
Otherwise you would have to read the file on client, send the data to server (by calling a server-bound method) and then process the data there.
Yep, that's what I did.
I read the file on client and sent it to server for further elaboration.
Thanks for advices!
Business Applications communities