[dba-SQLServer] sql2005 express to standard

I have always been the if not broke don't fix it guy (with a few
exceptions), if 2005 works for you why change it, also if you remove the
management studio before upgrading (not re-installing) to SQL Server 2005
standard, it "should" go without a hitch, without the need to
backup/restore or detach/attach the databases and the server instance
should remain the same.

Paul


On 17 March 2014 20:29, J- P <jnatola at hotmail.com> wrote:

> Hi all,
>
> we have an sql express database that has been running  for many many many
> years, we are getting a new timtrack software that they recommend to run on
> sql standard, a few vendors still have sql 2005std on hand for a really
> good price (we need the cpu license) , so the question i have is two-fold;
>
> a) is the best way to upgrade the current db to standard via back up
> /restore?
>
> b) is it foolish to purchase sql 2005 given that we are in 2014?
>
> Any thoughts/feedback. opinions would be greatly appreciated.
>
> TIA
>
>
>
>
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
Paul Hartland
paul.hartland at googlemail.com