![]() And we run the 2010/2012 packages on the 2008 database without any issues every night. I have several clients that are not ready to upgrade their DBs from 2008 to 2012, however they want to use some of the features available in BIDS/SSDT 2010 and higher. This will give your 2008 database the ability to run both 20 developed packages without any issues. You simply need to install the \Tools\Bin for the higher version of the database on the physical server, and modify the database config file to look for the higher version \Tools\Bin first, followed by the other Bins. However that doesn't preclude database 2008 from being able to run packages built on 2010 or higher because all MS 2005 and higher databases can read more than one version of the ddl. Those versions are stored in the \\Microsoft SQL Server\\Tools\Bin. Yes, VS 20 do use different versions of certain ddl files than the 2008 database does. Download and install SQL Server Data Tools (SSDT) for Visual Studio Conclusion In this article, we learned about how to download SQL Server versions, editions, sample database installation, Azure SQL and more. Hi Shawn, Thanks for the feedback but that's not entirely true.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |