installing backward compatibility server components in an existing sql server 2008 instance...does it work or not?
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, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
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: