> Date: Tue, 4 Feb 2014 17:28:57 -0600

> Subject: Conversions & Data Stores & Dinosaurs, Oh My!

> 1. If they insist on Oracle, am I dead in the water? I've never touched it.

> Cavalierly, I think it is just a SQL data base, and the data objects

> undoubtedly exist to do basic data manipulation. But I know there is a ton

> of admin -- I assume their DB admins can take care of this (?)

This is the only part I have experience with. One of my clients replaced my VFP system with a heavy-duty vertical market app using Oracle databases, to the tune of some 3 million $! The app worked OK, but getting the reports they were used to turned out to be a challenge, so I was tasked with producing the VFP Monthly Business Summary from Oracle data.

I copied the connection stuff from the Crystal Reports interface they had provided, wrote a great big SQL Select, with lots of joins, and son-of-a-gun, it all worked. Had one panic when it took 3 hours to run, because the DB Admin decided to change the index tags. I fixed it by changing my strategy. You definitely want to off-load the DBA chores to their Oracle folks, but the data part was fine.

Dan Covill

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/BAY169-W26A0193FC6BAA68BD17EA290950@phx.gbl

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.