We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL 2008 Express, but we are not upgrading the Client Tools; in fact many of our locations don't even have Client Tools installed, just the DB Engine.
I'm wondering, is SQLCMD packaged and upgraded with the DB Engine? If it is not, and only included with Client Tools (i.e. SSMS), then I think even if our locations had the SQL 2005 Client Tools installed they couldn't connect to the SQL 2008 DB Engine (I know SQL 2005 SP2 Update 5 and above can connect to a 2008 DB Engine, but I don't think these locations have the updates).
I've looked for documentation, but nothing seems to say if SQLCMD is upgraded with the DB Engine or the Client Tools.
Thanks!