September 21, 2006 at 7:07 am
Currently we have two processing environment..development and production on two separate servers. We are also in middle of moving to new servers. We will probably be building a QA environment in the future. Currently our processes query the servername name to determine where we are processing. And based on servername how we process. What this means, is whenever we replace servers all of our processes has be changed due to servername changing. Use of DSN alias is not an option on these particular servers. My initial thought was to setup a table which contains a column indicating environment (ie. development, QA, production). I'm welcome to any other ideas. Thanks.
September 22, 2006 at 12:29 pm
I personally like the idea od a lookup table that supplies this info to you. More importantly however I think you need to think about perhaps using a store procedure to get you this information. If you had a stored procedure that all of your other procedures called even if you were doing it the way you currently are, you'd only have to change the servername in that procedure once and you'd be all set, instead of having to change it in every procedure.
I suppose it's basically what you are doing with the table and the dev, Prod,QA values, Creating some sort of abstraction layer so that you don't have to change everything whenever you change server...
-Luke.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply