[dba-SQLServer] sqlexpress upgrade

Mark,

Manually, copy and paste. tedious for sure. Automatically, Red Gate or
ApexSQL are hard to beat. If you're in a SQL shop then you must have one of
these utility belts. I love them both. In fact, I love them so much that I
consider them a job-requirement. If the client dosen't have them, then I
won't accept the contract withtout one or the other in place. That's that;
no Ifs Ands or Buts. Give me the tools I need to do the job or find another
guy to for around. That's it. There are lots of clients in need of skilled
database experts. Give me the tools I need . At the end of the day, give me
the tools that  do the job, or find yourself another db expert.

On Mon, Dec 1, 2014 at 2:17 PM, J- P <jnatola at hotmail.com> wrote:

> Doing that as we speak,
>
> in so far as bringing over the maintenance routines and logins, is there a
> way to do it?
>
> the basic routines are , hourly transaction log backups, daily full,
> weekly integrity
>
>
>
>
> Jean-Paul Natola
>
>
>
>
> > From: marklbreen at gmail.com
> > Date: Mon, 1 Dec 2014 18:38:14 +0000
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: Re: [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
> > >
> > >
> > _______________________________________________
> > 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
>
>


-- 
Arthur