We are installing sql server Backward compatibility components in an existing sql server 2008 pre production environment. Does it works? usually I do database compatability for backward component is concerned but in this server we are doing server level
backward compatability in an existing instance of sql server 2008. Does it works? May I know How? or else SSMS is hanged in this case?
I have never seen any issues related to installing Backward compatibility components in an existing sql server ..
I know that The
SQL Server Backward Compatibility package provides the latest versions of Data Transformation Services 2000 runtime (DTS), SQL Distributed Management Objects (SQL-DMO), Decision Support Objects (DSO), and SQL Virtual Device Interface (SQLVDI). But what are
you expecting from SS2005 to SS2008? IIEW, we cannot use DTS in SS2008...
Best Regards,Uri Dimant SQL Server MVP,
Firstly, I want to confirm why you want to install SQL Server backward compatibility components. If there is any compatibility issue, please post the error message here for analysis.
I want to inform that different version SQL Server instances can be parallelly installed on the same Windows Server, and usually the newer version is compatible with the folder version (except some deprecated features). So if the function is included
in the newer version, we don’t need to install the older version any more. For more detail information, you can refer to the following link: