Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2012 upgrade. Expand / Collapse
Author
Message
Posted Monday, May 20, 2013 9:30 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 2:35 PM
Points: 354, Visits: 918

What are the benefits of upgrade to SQL Server 2012?

Can someone direct me to webcast benefits upgrade SQL Server 2008 R2 to SQL Server 2012

Thanks in advanced.
-Edwin
Post #1454801
Posted Friday, May 24, 2013 12:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:47 AM
Points: 118, Visits: 238
I would recommend you to take a look at the below mentioned links as a starting point to see new features in SQL Server 2012 which can excite you to upgrade to SQL 2012.

New Features in SQL Server 2012 for Database Developers
New Features in SQL Server 2012 for Database Administrators
New Feature in SQL Server 2012 Reporting Services for Developers
Indirect Checkpoints Feature in SQL Server 2012
SQL Server Paging Using OFFSET and FETCH Feature in SQL Server 2012
Using WITH RESULT SETS Feature of SQL Server 2012

You also need to keep in mind that if you upgrade to SQL Server 2012 then you can’t downgrade the database using backup and restore. The below mentioned links explains the same.

How to Downgrade SQL Server Database

The reason why you cannot downgrade a database using backup and restore command is mentioned below for your reference

Why an SQL Server Database from a higher version cannot be restored onto a lower version?

Hope this helps you!
Post #1456644
Posted Thursday, May 30, 2013 9:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 10:36 AM
Points: 123, Visits: 349
Can our client workstation development using SQL Server Native Client 10.0 be upgraded to SQL Server Native Client 11.0?
Where would that download for Native Client 11.0 (32 bit) be found?

Can the SQL Server 2008 r2 servers be upgraded with the Native Client 11.0 (or ODBC 11) to take advantage of the improved features?
Post #1458278
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse