SQL Upgrade-In-Place

[KirbyWallace]

I need to do an SQL 2000 to SQL 2008 upgrade on an existing server this weekend.

What I'm wondering is, will an upgrade in place actually do what it claims? Will the database accept all application connections using their existing connection strings and continue to work properly? Or does upgrading to 2008 mean having to make mods to all those apps?

Thanks,

Kirby

 

[mrdenny]

Yes it will do what it claims. No changes are required to connect to the SQL 2008 server.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog