THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Uri Dimant

Successful upgrade to SQL Server 2012

Hi everyone. A few days ago I successfully upgraded our production database to the new version -SQL Server 2012. Actually, all installation process went ok, and after running Upgrade Advisor I restored the database onto a new server without any problems. The "challenge" was to upgrade existing SSRS reports and SSIS packages. I migrated the entire solution of our reports and it looked ok but trying open the data source or even click on Properties ,I was kicked off and prompt to close or restart SQL Data Tools solution.What I would recommend is to open a new project in SQL Data Tools (yes BIDS is gone) ,creating a new data source and adding report by report to the project. SQL Server  will automatically upgrade them for first time you run it. Also ,SSIS package migration process went smoothly where I just needed to replace connection string for OLEDB source only.Another good thing is that now you can much easily configure SSRS and even if you specified not to "install and configure" during the installation.More over, I have not noticed any performance degradation since we moved from SQL Server 2005 after running Update Statistics on all user databases. So lets enjoy new features that were introduced and happy working with SQL Server 2012 to everyone.

Published Monday, April 23, 2012 3:38 AM by Uri Dimant

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

tosc said:

Hi Uri,

how do you check your transferred database? What about UPDATEUSAGE with count_rows, sp_spaceused?

CU

tosc

May 9, 2012 3:16 AM
 

Uri Dimant said:

Hi

What do you mean by "check"? I am running many things to check my databases like DBCC CHECKDB,check for fragmetnation and rebuild or reorg indexes based on fragmentatin level...

Specifically for count rows I use the below script

SELECT

t.name,

[RowCount] = SUM

(

CASE

WHEN (p.index_id < 2) AND (a.type = 1) THEN p.rows

ELSE 0

END

)

FROM

sys.tables t

INNER JOIN sys.partitions p

ON t.object_id = p.object_id

INNER JOIN sys.allocation_units a

ON p.partition_id = a.container_id

GROUP BY t.name

ORDER BY RowCount DESC

May 9, 2012 3:26 AM
 

tosc said:

Uri,

I'm asking if there are some specials, i.e. errors by upgrade etc...?

May 9, 2012 3:40 AM
 

Uri Dimant said:

You have to run Upgrade Advisor to capture such things

May 9, 2012 3:45 AM
 

mm said:

ok

November 1, 2012 1:29 AM
 

nILOY said:

I AM A NEW DATABASE ADMINISTRATOR, CAN YOU GIVE COMPLETE PROCESS OF UPGRADING FROM SQL SERVER 2005 TO 2014?

THANKS

December 2, 2014 4:19 PM

Leave a Comment

(required) 
(required) 
Submit

About Uri Dimant

Uri Dimant
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement