[QUOTE=James Heinrich;379453]There's not [i]many[/i] major compatibility issues across the minor versions, probably the most notable one being ereg* functions being deprecated (in favour of their preg* equivalent) in v5.3+. Another gotcha that I've seen crop up is the default characterset for htmlentities in v5.4+. For what it's worth, the current server is running PHP v5.2.5.[/QUOTE]

Here is a short list of incompatibilities between PHP 5.4 and 5.5:

[url]http://php.net/manual/en/migration55.incompatible.php[/url]

What a great idea: [URL]http://www.wfsb.com/story/26174225/police-do-not-call-us-if-facebook-is-down[/URL].

I'll have to remember that the next time that PrimeNet is down. :cmd: Where should I call -- San Diego police, or maybe the FBI? :wink:

Rodrigo

[QUOTE=Madpoo;379446]I've offered up a DL360 G5 server, but it sounds like it comes down to Scott's okay on it since he's the point person for physical access to the server itself. Just on the off-chance he wants it, I got the hardware together and installed Server 2012 on there...[/QUOTE]

George, sorry for being annoying, but as the saying goes, "the squeaky wheel gets the grease".

Any thoughts from you and Scott about Madpoo's very generous offer?

[QUOTE=chalsall;379579]George, sorry for being annoying, but as the saying goes, "the squeaky wheel gets the grease".

Any thoughts from you and Scott about Madpoo's very generous offer?[/QUOTE]

Madpoo and I are are actively working through a plan to migrate to his new server. Don't expect anything quick. We are looking at how to copy all the software, 25GB of data, and test it before shipping to San Diego. The goal is to be sure the transition is as easy as possible once the hardware arrives in its new home.

The only issue I can see that would scuttle this is whether madpoo has a valid donatable license to Windows and SQLServer. You'd think that would be trivial to figure out but MS licensing is a labyrinth.

[QUOTE=Prime95;379583]The only issue I can see that would scuttle this is whether madpoo has a valid donatable license to Windows and SQLServer. You'd think that would be trivial to figure out but MS licensing is a labyrinth.[/QUOTE]

Yeah, so far I've gone back and looked at our old licenses for SQL/Windows and I'm coming up with a ton of old volume licenses, but those aren't transferable.

I'm pretty sure that at some point I had some retail licenses so I'm hoping as I dig through invoices for the past few years I'll find it.

If there is anyone out there who had a retail license of Windows 2008 or SQL 2008 (not a volume license or enterprise agreement) and then bought a new one for Server/SQL 2012, then that old license should be able to transfer, I think. As George said, MS licensing is kind of strange, but for transferring older products it's a little more straightforward, especially the retail packaged stuff.

They have non-profit pricing for MS products, FWIW.

I *do* have entire volume licensing agreements that were superseded... that is, a full VL suite for 2008 products (purchased in 2007) that we replaced with software assurance in 2008. I just don't know if those could be transferred... it's one of those things where it was cheaper to go to SA and basically abandon our investment of 50 server licenses (we'd only used 4 of them at the time).

I hate MS licensing, by the way. Like the products, but the licensing sucks. :smile:

I'm going to take the server down for some more maintenance. Clustering some indexes, some redundant index removal, and some other stuff. Cross your fingers.

Does this mean the Bus factor is 2.01 and slowly rising to 3? That would be nice.

Woo Hoo! It's Alive I tell you, Alive! 0427 UTC, 8/3/14

Yes, we're back. I completed worked on 6 tables -- clustering and rebuilding indexes. Removed one redundant index. Altered one column to NOT NULL (to save a couple of bytes in an index key).

I didn't get to 5 more tables. One redundant index on 20 million rows can be deleted. A few more columns can be changed to NOT NULL if there is enough disk space to create a transaction log.

The database has 9 GB free now -- but that cannot be turned into free disk space without destroying all that hard work defragging the indexes. There is 4GB free disk space, so we are not in bad shape.

Many thanks! :tu:

[QUOTE=Madpoo;379585]If there is anyone out there who had a retail license of Windows 2008 or SQL 2008 (not a volume license or enterprise agreement) and then bought a new one for Server/SQL 2012, then that old license should be able to transfer, I think. As George said, MS licensing is kind of strange, but for transferring older products it's a little more straightforward, especially the retail packaged stuff.

[snip]

I hate MS licensing, by the way. Like the products, but the licensing sucks. :smile:[/QUOTE]

Just out of interest, could you give us all an idea as to how much it would cost for Mersenne Research, Inc. to purchase new licences of the required software?

And, to reflect, I personally hate the fact that the effectively zero cost to reproduce "bits" (read: proprietary software) often costs more than the hard to reproduce "atoms" (read: hardware).

And yet the latter probably took more money to develop, and definitely more to produce, and they have to get it right at release, rather than the "upgrade treadmill" of the former.

/end_rant