This is an automated archive made by the Lemmit Bot.

The original was posted on /r/talesfromtechsupport by /u/Elegant-Winner-6521 on 2023-11-01 17:40:51.

A brief summary of the conversations over the last month:

Me: so how much of your data do you need to migrate?

Client’s Head of IT: should just be some person records, some company records. that about right Operations Manager?

Client’s Operation Manager: yeah, not even. Just a subset of that.

Me: so its just flat data? Like one row for one person, no linked tables?

Client’s Head of IT: Correct. And we don’t even need much there, just the basic name, address, phone number etc will do.

Me: How clean is the data? Are you sending all of it and expecting us to clean it, or are you sending just the stuff you want to keep?

Client’s Head of IT: Oh we definitely don’t want that in the new system, so we will just send over the parts we want.

Me: are you sure? are you absolutely doubly sure? pinky promise no take backesies?

Client’s Head of IT: Yeah, but tell you what let’s have a call next week with our Data Guy.

Today

Data Guy: Yeah so we have two unique databases we need to merge, one in india and one in England. Hundreds of thousands of person and client records, millions of contact log records. For each worker there will be around 100 unique fields that need to be mapped, and for each worker around a thousand records for previous work history and communication logs, an unknown amount of documents but let’s say at least 20 PFDs per person. There’s around 200 directly relevant tables, but a lot more that could be useful.

Me: do you want some of this or all of it?

Data guy: …yes? We need this import to perform a data cleanse as we don’t have the capacity.

I should know better at this point, I fall for it every time.