SQLServer & Windows Vista Compatability
Few Quick Things to remember if you are migrating to Vista and you have your application using SQLServer:
- SQL Server 2000 and previous version are not going to be supported on Windows Vista or Windows Server Longhorn .This includes MSDE as well.
- SQL Server 2005 with Service Pack 1 or later will run on Windows Vista.
SQL Server Developer Edition, Workgroup Edition, SQLServer Express Edition and SQLServer Everywhere are supported with Vista. - Desktop Applciations compatible with Windows Vista can access a SQL Server 2000 databases on a separate server. Windows Vista will ship with the standard drivers that support OLE DB or ODBC access.
- As MSDE is not supported in Vista, migration of MSDE applications to SQLServer 2005 Express or Workgroup edition is required.
- MSDE features like DTS or SQL Agent are not supported in SQLServer Express edition. In such scenarios alternatives like using the DTS 2000 runtime which is a part of SQLServer 2005 backward compatability components might help. Also alternatives technologies like Service Broker might help to replace SQL Agent's Scheduling functionality.
- MSDE 2000 may still sometimes get installed on Windows Vista and probably some functioality may still work. But this is not properly tested and documented by Microsoft and is not supported by Microsoft. Hence it would be at the risk of the owner to try using MSDE with Vista.
More Details here http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx
Windows Vista Home: http://www.microsoft.com/windowsvista