Hello everyone. Thank you for your help.
We are using sql server 2005, and writing stored procedures and user defined functions. We have just introduced a complex test environment that is going to make our t-sql code management very complicated, could use your ideas how to simplify this.
*** The problem: in our development and test environment we're looking at maintaining 9 different versions of each user defined function (udf) we create. This is way too many versions, we'd like to cut it down to 3 versions or even 1 version if possible
of each udf. ***
1) We will be developing and testing our udfs in 3 test environments - development (DEV), and two end user test regions - UAT, QAT. Each 'region' is a separate sql server database.
.... so we're looking at 3 versions there, one version in each database.
2) And then, we have 3 different sources for our data: real time production (RT), a day end snapshot (DA), and a month-end snapshot (MO). Each of our functions will need to execute against each of these 3 data sources. Each data source resides in a separate
... so we now have 3 X 3 versions of each function; as mentioned first, one version in each development environment (DEV, UAT, QAT) and then each function in say DEV must be hard coded to run against each of our 3 data sources (RT,
View Complete Post