Post reply

2012 editions

  • August 27, 2012 at 2:46 pm

    #280477

    We are currently using SQL server 2008 R2 version, and most of servers are standard edition instead of Enterprise due to budget.

    Now I know SQL server 2012 they add another edition between Standard and Enterprise, which is called BI edition license.

    In our current 2008 R2, we use SSRS, SSIS, SSAS.

    My question is when upgrade from 2008 R2 to 2012, if we still use standard edition, our SSIS packages, and SSRS reports will still run with the features available before, correct?

    We don't need to buy BI edition license, do we?

    Thanks

  • August 27, 2012 at 3:14 pm

    #1530540

    My recommendation is to compare the features between your current version and the 2012 versions. Easier for you to do this than wait for someone here to do it and report back.

  • August 27, 2012 at 3:20 pm

    #1530543

    Thanks, I thought this forum may have already some dba upgraded previous standard version which they use ssis, ssrs, now upgraded to standard 2012. They may have experience about it and know pro and cons.

    So would like to hear about that.

    I have compared the features,we may stick on Standard edtion and when we purchased 2008 R2 standard, we purchase with SA, so if we upgrade to BI, we may have to pay additional money for it.

    We may stick on standard because of the budget

  • August 28, 2012 at 8:15 am

    #1530839

    I've done a number of upgrades to 2012. There's no special things you need to do going from Standard to Standard in 2012. The upgrade process is pretty similar to every other upgrade I've done in SQL Server over the years. Use the Upgrade Advisor first in order to identify any issues. Address those. Then pick your migration process, in-place upgrade or side-by-side. I always find the side-by-side to be my preference because it's safer. However, it is a lot more work. You'll need to migrate all databases, logins, Agent jobs and the security. While the in-place is safer, if something goes wrong, you have no fallback position. Backup and test your backups prior to migration. Migrate to a test environment first and then test your app code. Fix anything that went south on the test and then retest.

    "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 28, 2012 at 9:23 am

    #1530888

    Thanks, do you use BI - SSIS, SSRS in those boxes?

    From what I read, it seems they carry over all the features, it won't lose any features if still using standard edition, the BI edition just add some advanced feature like powerview, powerPivot and self- service BI

  • August 28, 2012 at 9:28 am

    #1530897

    I have not used the BI edition. Standard or Enterprise is all I've done. Yes, I've done SSIS & SSRS. They're the same, effectively, in terms of licensing, as the old Standard & Enterprise versions. No changes. If you have serious questions about licensing, I strongly recommend getting in direct contact with Microsoft.

    "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 28, 2012 at 9:29 am

    #1530898

    Thanks!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply