Hi there. Before I start rambling information I'll tell you I'm not from San Antonio, but my family lives there and are ALL in education (superintendent, vice principle, teachers, schools named after them, nutritionist for district, etc). I just did all the research of SA for my cousin who's transfered from Saudi Arabia (military).
Ok, the BEST districts are Northeast and Northside. In Northeast, Reagan is the best high school so any elementry to feed to that high school will be good. It is the newest. Churchhill is also great. CHECK CAPS. Some schools are caped. Your realitor will know. They are opening a new HS in 2008 to help with this problem. Middle schools to feed to are Bush and Tejeda. Subdivisions are Stone Oak, Rogers Ranch, Champions Ridge, Sendora Ranch.
Northside high schools to feed to are O'Connor and Clark. All I have mentioned are 5A and have excellent athletic programs, high acedemic achievement scores, most AP kids, good band, etc. OConnor subdivisions are Helotes, Dominion (stars live there...high priced).
Subdivisions to look at are outside 1604! Depending on the location of your husband's job and your desire for a small school, you may also look at living in New Braunfels. It's not far (just out 281) and has great schools and is a nice smaller town.
A side note, living far from your job in SA is not the same as Dallas. Traffic is not as bad and everything seems to be closer. I would talk to your realistate agent about commutes.
Ok, that's all I have. Hope that helps.
A. Cody