July 12, 2011 at 4:06 am
Hi,
We have a database running on SQL Server 2005 instance. Now we have prepared a different server with SQL Server 2008 R2 installed on it, and we have restored the backup of the database (taken from SQL Server 2005) in the instance of SQL Server 2008 R2. The restoration has been successful. Now we need to know if any issues arise after we go live with the database, such as any functions/procedures supported by SQL Server 2005 are not present in SQL Server 2008 R2, and they are being used in the database. We ran SQL Server 2008 R2 Upgrade advisor, but it didn't show any alerts on the database residing in SQL Server 2005. Rather it raised alerts on issues such as Full Text Search and ORDER BY clause used in a stored procedure in a system database (not the database we are using). I also checked the discontinued and depreciated features in SQL Server 2008, but they were mostly about the SQL Server services, rather than any functions/procedures that are not supported. Please advice whether we should be okay with going live with this or we need to perform some other checks.
Regards,
Hammad
July 12, 2011 at 4:29 am
Hello hammad772001,
We have done the same as you, a restore of sql 2005 database to an sql 2008 database.
The way to verify syntax of procedures and vues, is to be able to re-execute them on the sql server 2008 database.
I would generate the script, and replay it, to see if there are any compile errors or so.
hope this helps.
Kind Regards,
Oussama Dinia
.NET Solutions Architect
http://devmeetsbi.ghost.io/
http://www.devmeetsbi.io/catalog/3079
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply