technology

24152 readers

157 users here now

On the road to fully automated luxury gay space communism.

Spreading Linux propaganda since 2020

Rules:

1. Obviously abide by the sitewide code of conduct. Bigotry will be met with an immediate ban
2. This community is about technology. Offtopic is permitted as long as it is kept in the comment sections
3. Although this is not /c/libre, FOSS related posting is tolerated, and even welcome in the case of effort posts
4. We believe technology should be liberating. As such, avoid promoting proprietary and/or bourgeois technology
5. Explanatory posts to correct the potential mistakes a comrade made in a post of their own are allowed, as long as they remain respectful
6. No crypto (Bitcoin, NFT, etc.) speculation, unless it is purely informative and not too cringe
7. Absolutely no tech bro shit. If you have a good opinion of Silicon Valley billionaires please manifest yourself so we can ban you.

founded 5 years ago

MODERATORS

context@hexbear.net

SexUnderSocialism@hexbear.net

gaycomputeruser@hexbear.net

Wakmrow@hexbear.net

SwitchyandWitchy@hexbear.net

Help me hexbear techies, you’re my only hope🥺 finally got a job in data migration, but the company doesn’t have any architecture in place/tools to make data migration possible (hexbear.net)

submitted 2 months ago by Hohsia@hexbear.net to c/technology@hexbear.net

9 comments fedilink hide all child comments

And they’re leaving it in my hands 🙃

Anyone have any suggestions for tools/technologies to look into? It will most likely take the form of csv extracts from system A with fields/objects to be mapped to system B.

Also, this question is truly an instance of how the internet is a fucking wasteland. I could’ve asked this question 5 or 6 years ago on Reddit and gotten something meaningful, but today I would get replies from tons of company accounts trying to sell me their garbage solutions based on LLM wrappers

you are viewing a single comment's thread
view the rest of the comments

[–] leftAF@hexbear.net 11 points 2 months ago* (last edited 2 months ago) (1 children)

Use dbt, host it on whatever they got (vSphere, cloud VMs, w/e) or schedule it the same way their "Devops" or "CICD" pipelines are orchestrated. Makes it easier if you wind up having a bunch of workers move data in parallel during the migration window or if you need to do a rolling refresh of the destination for validation or something.

If you can get access to the source database, query the INFORMATION_SCHEMA views (select * from information_schema.columns) to get the data types of the fields in the source system. Same for the destination it sounds like, but once you have the columns and tables present in both systems you can probably start mapping it easily or chatbots probably do OK at it.

[–] Hohsia@hexbear.net 1 points 1 month ago

What is dbt? Dealing with azure here too, but no access to anything other than SOQL (platform sits on top of salesforce)