New answers tagged data-warehouse
My answer is a big YES - you should store business logic in data warehouse. That is one of the ideas of data warehouses in the first place. If you have tens of reports showing or filtering leads imagine if a rule to qualify someone as lead would change. Also, what if you have to access DWH data with different tools/systems - you'd need to replicate all the ...
Check out Attunity Replicate and Golden Gate from Oracle. Other native options include using service broker or SSIS with WMI polling. If you have SQL Enterprise however CDC is would be the best option in terms of maintainability.
If you need something fairly quick and dirty to compare schemas, I wrote this gist to help compare a running schema to a "latest" schema -- something maybe hosted in SCM. It's working fairly well for a ~50 tables project.
Top 50 recent answers are included