What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
Course Of The Month
8 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
upgrading SQL database
Posted on 2012-12-20
Hi.
Consider the following scenario,
An application is compatibile with windows sql server 2003.
Now a service pack has to be added to this baseline version of this application.
After implementing this SP, the application could be run and is compatible with sql server 2008.
A fresh installation of the baseline version of application has to be installed on workstation and then SP implemented on top of it.This makes the application compatible to be run with windows sql server 2008.
Can an existing database (sql server 2003) be upgraded to sql server 2008 on the machine on which it is running at that moment.
Consider the following scenario,
An application is compatibile with windows sql server 2003.
Now a service pack has to be added to this baseline version of this application.
After implementing this SP, the application could be run and is compatible with sql server 2008.
A fresh installation of the baseline version of application has to be installed on workstation and then SP implemented on top of it.This makes the application compatible to be run with windows sql server 2008.
Can an existing database (sql server 2003) be upgraded to sql server 2008 on the machine on which it is running at that moment.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
5 Comments
Active 3 days ago
did you mean sql server 2005 ?
yes, but it depends on what edition do you use:
if standard to standard ; etc.
however, you must review and address if there are any issues
Useful links for upgrading to SQL Server 2008
http://blogs.msdn.com/b/sqlcat/archive/2009/03/27/useful-links-for-upgrading-to-sql-server-2008.aspx
yes, but it depends on what edition do you use:
if standard to standard ; etc.
however, you must review and address if there are any issues
Useful links for upgrading to SQL Server 2008
http://blogs.msdn.com/b/sqlcat/archive/2009/03/27/useful-links-for-upgrading-to-sql-server-2008.aspx
Active 3 days ago
Version and Edition Upgrades
http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx
thanks Eugene.
I am doing a fresh installation of a application xyz.
I install the baseline version.
The baseline version is compatible with MS SQL 2005 but not MS SQL 2008.
THe application while installation asks for instance and database.
I then install the SP on the baseline version.
After implemeting SP on the baseline the application could be run with MS SQL 2008.
I have a fresh database server with MS SQL server 2008.
What if I am doing a fresh installation of the application first (compatible with MS SQL 2005).
Can I point the application to the old database MS SQL 2005 while installing the baseline and then implement the SP and then somehow point it to MS SQL 2008.
I am doing a fresh installation of a application xyz.
I install the baseline version.
The baseline version is compatible with MS SQL 2005 but not MS SQL 2008.
THe application while installation asks for instance and database.
I then install the SP on the baseline version.
After implemeting SP on the baseline the application could be run with MS SQL 2008.
I have a fresh database server with MS SQL server 2008.
What if I am doing a fresh installation of the application first (compatible with MS SQL 2005).
Can I point the application to the old database MS SQL 2005 while installing the baseline and then implement the SP and then somehow point it to MS SQL 2008.
Active today
That should work, if you know how to change the instance and DB info of the application. We cannot answer that question, because it is nothing more than the application logic and configuration which determines which server and DB to use.
Do you have sqlncli.exe on the client, that is, is the MSSQL native client installed? With "SQL Server Configuration Manager" (sqlncli.exe) you can define Aliases for MSSQL - so you can rename the MSSQL 2005 connection to be the same as the 2008 one for installation, and then remove that alias, or change it to point to the 2008 server.
Example:
Your MSSQL 2005 is named mssql\sql2005, the correct one is mssql2008\sql2008.
You create an alias called mssqlapp, pointing to server mssql\sql2005.
The application's db server to use is mssqlapp.
After applying the service pack, change that alias to point to mssql2008\sql2008.
Do you have sqlncli.exe on the client, that is, is the MSSQL native client installed? With "SQL Server Configuration Manager" (sqlncli.exe) you can define Aliases for MSSQL - so you can rename the MSSQL 2005 connection to be the same as the 2008 one for installation, and then remove that alias, or change it to point to the 2008 server.
Example:
Your MSSQL 2005 is named mssql\sql2005, the correct one is mssql2008\sql2008.
You create an alias called mssqlapp, pointing to server mssql\sql2005.
The application's db server to use is mssqlapp.
After applying the service pack, change that alias to point to mssql2008\sql2008.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month8 days, 8 hours left to enroll
617 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.