Hi Mikel, Sounds like a viable approach which could be applied for my case too.
1. There is no need for me to store remote txn data on the legacy oracle schema as it will be redundant and unnecessary duplication. I just want to be able to read 10 columns from legacy table and store it in application table to be used at a later point in time. So, Using Ruby OCI to fetch data from Legacy Tables with Search Criteria and i can write these into files initially for reports and also store in secondary DB. For storing into secondary DB? 2. How to migrate or Write that into local application table. a) should i use migrations as i have models. b) or use just pure SQL to insert rows in to my tables? c) use this How and what did you do with your daemon? Does RoR provide with an efficient migration technique from legacy tables? 3. Totally Agree. As such there are other application related data which i will use locally for faster processing. The only overhead is getting data from legacy system ONCE and store it for local processing. Any suggestions? /Sudhir Mikel Lindsaar wrote: > On 16, April 2010, at 16 Apr 13:42, Blue Bull wrote: >> The Legacy tables are hug, being used by umpteen other apps. hence, i >> want to search once and store data within application table for >> processing as and when required. >> Is it viable to create models in my app, migrate search data for each >> result row into the app table? Or is it just better to create dynamic >> views within oracle DB everytime a query is initiated and use this data >> for reporting purposes? > > When I had the same issue (except I also had an MS SQLServer in the mix > as well as my RoR app's PostgreSQL database) I did a mix of things. > > 1) views on the Oracle server for stuff that can be kept remote > 2) Local copy of static Oracle data done through a replication deamon > that I wrote > 3) Queries on the local data for speed > > Mikel Lindsaar > > http://rubyx.com/ > http://lindsaar.net/ -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
