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