AmmarDJ
asked on
upgrading SQL database
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.
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
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<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. >
yes, you can -- it is your application connection string setup (as per Qlemo- check your code)
yes, you can -- it is your application connection string setup (as per Qlemo- check your code)
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