12-31-2007, 09:29 AM
|
#2 (permalink)
|
| Programmer Analyst Join Date: Feb 2007 Location: St. Cloud, Minnesota
Posts: 45
Rep Power: 0 
| Hi Donna,
A big resource I use is at "C:\Program Files\Blackbaud\The Raisers Edge 7\Help\RE7Schema.chm"
This shows much of the schema and how it relates. It only covers tables and views though. Often times I end up running a trace (sql profiler) and learning more that way. RE uses a lot of stored procs and functions, so you'll want to check those out too.
Before this job, I was strictly oracle (pl/sql) as well. My biggest problem - still is - are the outer joins in t-sql. I just can't get used to the different syntax.
Good luck digging around on the back-end. You'll find Blackbaud is no help though - I've tried and they warned me that I was violating our maintenance agreement by messing around back there.
Dan
__________________
Real programmers don’t document. If it was hard to write, it should be hard to understand. |