kevaburg (12/5/2016)
Jeff Moden (12/5/2016)
kevaburg (12/5/2016)
Have you maybe thought about creating a file watcher task that can be used as a trigger to automatically run a script when it is dropped into a folder?That would help the DBA. The real question is, why do the Developers need to make daily corrections to data? Something's wrong there. If the corrections are from customers, then the process needs to be automated in full instead of the current throws both the Developers and the DBA are going through.
I agree 100% with you but unfortunately I work in a Company that has an unsupported Version of Axapta as ist ERP solution running on unsupported Hardware, utilised by unsupported applications. Because everything around this (BI, EDI, PLM etc) is based on this database we find updates being rolled out in the frequency that the OP is experiencing. Oh yes, and the anticipated turnover for 2017 is €2bn......a Company that truly doesn't care about ist data.....
I offered the file watcher solution because I truly feel for him and the Situation and the very real possibility that in his Company he is the only one that cares.....
Make no bones about it, the file watcher solution would definitely be a reasonable solution for the DBA. I wouldn't auto-magically make things run at the appearance of the file because someone might put an early file out there and then decide they did something wrong. I'd make it a scheduled job.
Still, I can help but think that Developers shouldn't be responsible for the creation/repair of data so often unless it's coming from a 3rd party as data updates, in which case, it should all be automated. Even ERP solutions typically have a method for exporting data on a scheduled basis. Even the unsupported versions.
--Jeff Moden
Change is inevitable... Change for the better is not.