I want to install SharedManagementObjects for SQL server 2012 express on a windows xp sp3 machine that has SQL Server 2008 R2 Express edition but does not have any edition of SQL Server 2012.
But one of the prerequisites for installing "SharedManagementObjects for SQL server 2012" is that microsoft sql server 2012 system CLR types must be installed.
I see i can download the SQLSysClrTypes.msi i need from Microsoft® SQL Server® 2012 Feature Pack
but am not certain it will successfully install on a windows XP SP3 machine that has .NET 4.0 and Windows installer 4.5 but no SQL Server 2012.
EDIT: Same problem as this http://social.msdn.microsoft.com/Forums/nl/sqlsmoanddmo/thread/6bcde08f-e848-40a0-bc1f-e2f803a125da
I want to do this because i have an application whose backend database can either be SQL Server 2008 R2(for clients running windows XP SP3) or SQL Sever 2012(for clients on Windows Vista and above).
This application uses SMO for doing programmatic backup and restore operations.
Now in my application when i reference SMO for SQL Server 2008 R2, backup and restore fails on systems that have SQL server 2012.
If in my application i reference SMO for SQL Server 2012, backup and restore fails on systems that have SQL server 2008 R2 (i.e XP3 clients).
What is the common best way of handling such a requirement? Or what alternatives do i have?
All i need is for the WinForms application to support both SQL Server 2008 R2 and SQL Server 2012 and their corresponding versions of SMO.
The System Requirements section on that download page is pretty clear:
System requirements
Supported operating systems: Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, Windows Vista Service Pack 2
There's no mention of Windows XP SP3 - so no, you cannot install this SMO library on Windows XP SP3. Time to upgrade.