On Sun, Oct 1, 2017 at 4:24 AM, Ben Edwards <
lo...@funkytwig.com> wrote:
> Mine is! Maybe I should call it something else but in my 25 years in IT
> i've worked on several projects that use data in a database to transform
> data and transformation change (i.e. data warehouse load scripts).
I can't even parse what that sentence means, so...
>> A "staging" server is for realistic testing of your *procedures* that will
>> run on production, not doing data transformation to export.
>
> Again, maybe we need to call the server something else. Also it is testing
> (or the transformations).
Using commonly agreed-on definitions of things is generally a
Good Idea, especially given that Rails is a convention-oriented
framework.
> Anyway worked it out. I simply reaload the reference tables. The trick is
> to keep all the keys the same and use deferred foreign keys.
Sounds operationally brittle, but I'm sure your customers will let
you know when that stops working :-)
> Rules are there to be broken;).
"Good decisions are based on experience; experience is based
on bad decisions."