none
management and maintanence of 2008r2 developments with 2012 client tools

    Question

  • Hi eb

    I need to manage and maintane sql server 2008r2 developments like databases,ssis packages,ssrs reports,ssas native cubes

    and at the same time start developping in 2012 tools for 2012 servers with thier own version of client tools.

    Questions:

    Can 2008r2 and 2012 client tools co-exist on the same development machine?

    Are there any known issues with development of any of the sql server 2008r2 components after instalation of the 2012 client components?

    I guess it is not possible to uninstall the 2008r2 client tools alltogther because managing 2008r2 developments from within 2012 client tools would automatically upgrade them to 2012 version (as was the case with the 2005-2008 versions before)?

    Last and not list do 2012 client tools require windows 7 OS?

    TIA for your attention

    Rea


    Sunday, April 13, 2014 8:13 AM

Answers

All replies

  • Hi eb

    I need to manage and maintane sql server 2008r2 developments like databases,ssis packages,ssrs reports,ssas native cubes

    and at the same time start developping in 2012 tools for 2012 servers with thier own version of client tools.

    Questions:

    Can 2008r2 and 2012 client tools co-exist on the same development machine?

    Are there any known issues with development of any of the sql server 2008r2 components after instalation of the 2012 client tools?

    I guess it is not possible to uninstall the 2008r2 client tools alltogther because managing 2008r2 developments from within 2012 client tools would automatically upgrade them to 2012 version (as was the case with the 2005-2008 versions before)?

    Last and not list do 2012 client tools require windows 7 OS?

    TIA for your attention

    Rea

    Sunday, April 13, 2014 8:19 AM
  • >>>Can 2008r2 and 2012 client tools co-exist on the same development machine?

    Yes, they can , but you can develop SSIS 2012  to work against SS2008R2


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, April 13, 2014 8:29 AM
  • a bit more reading revealed the SSDT configuration property

    'TargetVersionServer' which could be set to 'SqlServer 2008 r2 or later'.

    Does this solve the backward compitability issue of developping 2008 r2 products

    from within 2012 client tools all together?

    Does this property\backward compitability exist for all sql server 2008r2 components developments

    (databases,ssis packages,ssas native cubes,ssrs)?

    Thanks again!

    Rea

    Sunday, April 13, 2014 8:33 AM
  • a bit more reading revealed the SSDT configuration property

    'TargetVersionServer' which could be set to 'SqlServer 2008 r2 or later'.

    Does this solve the backward compitability issue of developping 2008 r2 products

    from within 2012 client tools all together?

    Does this property\backward compitability exist for all sql server 2008r2 components developments

    (databases,ssis packages,ssas native cubes,ssrs)?

    Thanks again!

    Rea

    Sunday, April 13, 2014 8:33 AM
  • Thanks so much Uri

    Can u refer to my aditional massage below?

    Would u recommand then to abondan the 2008r2 tools alltogether in such a scenario?

    Are u aware of any indications to retain a double tools installation?

    Thanks again

    Rea

    Sunday, April 13, 2014 8:39 AM
  • Yes you can install multiple versions of client tools of SQL Server and use them all, I have it on my machine I did not face any issue till now.
    Sunday, April 13, 2014 9:06 AM
  • I have one server where we mix the client tools, we develop the packages only in "high" version of the SQL Server... No problems so far :-)

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, April 13, 2014 9:21 AM