[dba-SQLServer] sqlexpress upgrade

Hello JP,

there sure is,

1) grab any old windows 8.1 box and install SQL 2014 express on it
2) change your connections strings and test your app against that new temp
machine.

I would expect that you have a very good change that it will work straight
away unless you are using advanced features, DTS etc.

You may be lucky but the other route will also require plenty of luck.





On 1 December 2014 at 18:14, J- P <jnatola at hotmail.com> wrote:

> Yes the box is being replaced, my concencern is that this custom database
> was developed in 1997 (started  as access)
> then went on to sql 2k express then 2005 express, how can i be  SURE that
> it will function under 2014?
>
> I have read (and I'm by no means a DBA) that alot of features were
> deprecated ,
>
> is there a way to test this?
>
>
>
>
>
>
>
> > From: marklbreen at gmail.com
> > Date: Mon, 1 Dec 2014 09:05:29 +0000
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: Re: [dba-SQLServer] sqlexpress upgrade
> >
> > Hello Jp,
> >
> > Are you planning on also replacing the 2003 box?  If so, I would suggest
> >
> > 1) purchase a new machine and install Win2012
> > 2) install sql 2014 express
> > 3) back up and restore your db
> > 4) forget about it for another 10 years.
> >
> > if you do not want to purchase an expensive server, just use a pc with
> 16gb
> > ram.
> > if you are really on a budget, use Win 8.1 as the host OS,
> >
> > regardless, I would not waste hours and risk all sorts of unknown errors
> in
> > doing a multi-stage upgrade.
> >
> > Your time is more valuable and a €600 machine.
> >
> > Mark
> >
> >
> >
> >
> > On 30 November 2014 at 16:27, J- P <jnatola at hotmail.com> wrote:
> >
> > > Hi all, this is a 2 parter
> > >
> > > 1.) I have a sqlexpress 2005 database on a 2003 server, as 2003 is
> nearing
> > > EOL (as is the hardware ) i *THINK* perhaps this may be a good time to
> > > upgrade the DB to a newer version ? (any thoughts/suggestions )
> > >
> > > Assuming I do upgrade to 2008r2 express, is it better to install a
> fresh
> > > 2008express and do  a restore of the database via SSMS, or install
> > > 2005express restore the DB, then install 2008 and let the wizard do the
> > > upgrade?
> > >
> > > 2.) There are a bunch of mtc routines amongst other things I'd like to
> > > keep/migrate to the new server, is it possible to restore the master
> DB to
> > > the new machine? if so is this recommended/advised?
> > >
> > > **This is a production server so upgrading to 2008express  on the live
> > > server is not an option**
> > >
> > > TIA,
> > >
> > > J
> > >
> > >
> > >
> > > _______________________________________________
> > > dba-SQLServer mailing list
> > > dba-SQLServer at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > http://www.databaseadvisors.com
> > >
> > >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>