August 21, 2014 at 2:26 am
Interesting one came up today, it seems our BI guys have been developing IS,AS,RS packages for SQL 2012 in VS 2012.
As SSDT for SQL 2012 is a VS 2010 app, I just wanted to know if there was any compatibility issues in using VS2012 for a SQL 2012 SSDT project.
Generally I'm a person who uses whats on the installation media for the version of SQL, so I would use SSDT in VS2010 for SQL 2012, BIDS in VS2008 for SQL 2008 etc.
You can download the templates for VS2012 from here by the looks of it (http://www.microsoft.com/en-gb/download/details.aspx?id=36843) but just wanted to understand to compatibility around it.
I know VS2013 wont work with SQL 2012 (read that somewhere but trying to re-find the link, will update when I can)
Thanks
Ant
August 21, 2014 at 2:42 am
If you develop projects in VS2012, you probably get an error when you try to open them in VS2010 (I tested it a year back and as far as I remember there were some issues).
VS2013 is for SQL Server 2014.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 21, 2014 at 3:19 am
I'm pretty sure most of the projects are backwards compatible within Visual Studio, but only across two-three versions. Database projects where that way within SSDT. Not sure about SSIS, etc.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 21, 2014 at 3:32 am
Grant Fritchey (8/21/2014)
I'm pretty sure most of the projects are backwards compatible within Visual Studio, but only across two-three versions. Database projects where that way within SSDT. Not sure about SSIS, etc.
I think the question was about the BI tooling, where projects are not really backwards compatible. At least for SSIS; SSAS and SSRS are pretty OK, but mostly because Microsoft didn't really bother making changes to these products in the last 6 years.
An overview:
Setting things in the right compatibility view
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 21, 2014 at 5:08 am
Yes its more of a if I developed a package in VS2012 using the templates downloaded from the link above, will it cause any issues with SQL 2012?
As detailed, I wouldn't generally do this, if SSDT ships as VS2010 for SQL 2012, then I use VS2010 for all my SQL 2012 packages, just the BI guys have gone with using VS2012 instead.
August 21, 2014 at 5:46 am
anthony.green (8/21/2014)
... just the BI guys have gone with using VS2012 instead.
They must like the monochrome colors... :ermm:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply