Sunday, October 1, 2017
On Friday, September 29, 2017 at 5:48:15 PM UTC+1, Hassan Schroeder wrote:
On Fri, Sep 29, 2017 at 8:55 AM, Ben Edwards <lo...@funkytwig.com> wrote:
If your reference data is *not* immutable load-one-time-only then
your change/transform/whatever process should live and run on the
production server.
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).
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).
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.
Rules are there to be broken;).
Ben
--
Hassan Schroeder ------------------------ hassan.s...@gmail.com
twitter: @hassan
Consulting Availability : Silicon Valley or remote
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/4639cd62-ee08-4196-a2bb-b272768af9f1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment