Ms sql 2005 too ms sql 2008 upgrade help
hey ppls
need your help again
i need too upgrade sql server 2005 too 2008 from the picture below
as i need too know the path for the media install folder thanks
http://endz.servegame.com/2005.jpg
as i want too upgrade the compatiblity level too 2008 please help
look
http://endz.servegame.com/help.jpg
Re: Ms sql 2005 too ms sql 2008 upgrade help
Why are you making things so difficult where you only need to get Microsoft® SQL Server® 2008 R2 and be done with it...
Re: Ms sql 2005 too ms sql 2008 upgrade help
right too start with this is a help topic were you post your difficult questions.
thats how im asking a difficult question
how can i be making it difficult ??
my server has ms sql 2005 and is running my instance for my database
i have installed ms sql 2008 r2 express
and i can load up the ms sql 2008 manager studio
and login with SQL server Authentication too the instance and import the databases
but the QUESTION THAT I WAS ASKING ?? was how too upgrade
as i have uninstalled 2005 and just installed 2008 but then i get no instance or instance ID
so i was thinking in trying the upgrade tool in ms sql server 2008 and too find out were too install the install media folder
that was my question
so please dont just give out the its the ms sql server 2008 r2 as there is a few of them
development
datacenter
work group
express
etc..
more info would have been nice..
Re: Ms sql 2005 too ms sql 2008 upgrade help
Assuming you have SQLEXPRADV_x64_ENU.exe(Microsoft® SQL Server® 2008 R2) on your hardrive..What you need to do is use winrar and extract the contents to a folder....
Then run appwiz.cpl in cmd and look for Microsoft® SQL Server® 2008 R2..Right click on it and choose unistall/change..There you'll get a pop up window choose ADD...
Now Browse for the SQLEXPRADV_x64_ENU.exe folder you previous Extracted and press OK...
Then let it do its thing...
Once it completes you should Be at the Installion type setup..
Here you can create new instances or manage old instances..
Goodluck...
Re: Ms sql 2005 too ms sql 2008 upgrade help
sorry for the other post there bud as i said its driving me crazy
i will try it your way if not then i just have too get a full version of 2008 r2 :)
on a page just now as we speak
16 parts lol and the first part is bigger than the ms sql 2008 i have lol
so maybe i have wrong version too manage instances
i will try this new download and if that works then all good and if that fails then i will try your way with the cmd
thanks bud for the quick replys and help its much appreciated