SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2012 upgrade.


SQL Server 2012 upgrade.

Author
Message
Ed7
Ed7
Say Hey Kid
Say Hey Kid (675 reputation)Say Hey Kid (675 reputation)Say Hey Kid (675 reputation)Say Hey Kid (675 reputation)Say Hey Kid (675 reputation)Say Hey Kid (675 reputation)Say Hey Kid (675 reputation)Say Hey Kid (675 reputation)

Group: General Forum Members
Points: 675 Visits: 930
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
Ashish Kumar Mehta
Ashish Kumar Mehta
SSC-Enthusiastic
SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)

Group: General Forum Members
Points: 140 Visits: 245
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!
Mile Higher Than Sea Level
Mile Higher Than Sea Level
Old Hand
Old Hand (362 reputation)Old Hand (362 reputation)Old Hand (362 reputation)Old Hand (362 reputation)Old Hand (362 reputation)Old Hand (362 reputation)Old Hand (362 reputation)Old Hand (362 reputation)

Group: General Forum Members
Points: 362 Visits: 465
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?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search