Mark Breen
marklbreen at gmail.com
Tue Dec 2 03:09:10 CST 2014
Hi Arthur, I agree, I am a subscriber to the redgate toolbelt for 4 years now, would not be without it. I participated in the ApexSQL beta testing in the very early years, about 2004 I think. On 1 December 2014 at 19:32, Arthur Fuller <fuller.artful at gmail.com> wrote: > 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 > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >