how to deploy xls with config based conn str (Dev vs Test vs Prod)
We have a lot of xls with vba/addins and so on that we are migrating to have
all the SQL as stored procs (with other enhancements coming later)
However, we want to fully control where a given xls gets its data from
Production, Test, Development etc
Is there a nAnt script or other deployment product that can do this?
If not, what workarounds do people use?
|