J- P
jnatola at hotmail.com
Tue Mar 18 11:05:08 CDT 2014
the main/only reason is the RAM, database size is not an issue I am going to have a teleconference with them at some point this week. I think they may be saying that in order to cover their rears should express not handle it well. Jean-Paul Natola > Date: Tue, 18 Mar 2014 15:29:05 +0000 > From: paul.hartland at googlemail.com > To: dba-sqlserver at databaseadvisors.com > Subject: Re: [dba-SQLServer] sql2005 express to standard > > Well then it comes down to cost and whether you or your company take the > chance on support ending and something going wrong, I had little > involvement with my two previous companies about the versions we installed. > In this case I would probably go the to company supplying the timtrack > software and ask them about newer express versions first, maybe SQL Express > 2012 Advanced maybe an option or why they recommend going to a standard > edition i.e. why do they say this, if it's the size of the databases 2012 > and (i think) 2008 upwards can support 10GB databases. Then when you get > the answers from them, put that along together with costs, pro's and con's > for your company and see what they say, or when you find out why your > timtrack supplier recommends standard editions, post back on here, just > because a company recommends it, doesn't mean it won't work with an express > version. > > Paul > > > On 18 March 2014 15:03, J- P <jnatola at hotmail.com> wrote: > > > My only hesitation about purchasing 2005 std is the fact that its > > approaching MS EOL > > > > > Date: Tue, 18 Mar 2014 08:10:14 +0000 > > > From: paul.hartland at googlemail.com > > > To: dba-sqlserver at databaseadvisors.com > > > Subject: Re: [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 > > > _______________________________________________ > > > 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 > > > > > > > -- > Paul Hartland > paul.hartland at googlemail.com > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com >