August 11, 2011 at 3:32 pm
I am Planning to Upgrade Prod SQL 2005 to SQL 2008 using in-place upgrade adviser. After Database upgrade do i need to re-point the Applications which connected to SQL 2005 or it will automatically re point because Server and db names are same???
Thanks for Help in advance..!!
August 11, 2011 at 3:35 pm
As long as the instance name stays the same (or it isn't a named instance) the connection string should remain the same as it was before.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 12, 2011 at 3:13 am
Sean is right this shouldn't be an issue, howerver there are two things to watch out for in my experiance;
Deprecated features / TSQL Syntax changes.
Log shipping will not work after the upgrade you will need to recreate it.
It may not be possible to migrate to a new SQL Server 2008 instance but where possible this would be my option of choice as you have many more options when it comes to the migration.
Thanks
Chris
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply