November 26, 2007 at 6:38 pm
Hi We are in the process of deciding which edition of SQL 2005 to purchase. we want a CPU licence version but are not sure whether to go for Standard, Workgroup or Enterprise - the one thing that we do know is DTS (i think MS have changed the name of this in 2005) and i'm not sure if the is included in all versions
Currently we have a web site based in the States using MySQL, we want to keep this but pull down the non web data locally and DTS clean the data into a MS SQL database which we will report of and run MS Access apps against
Any help / advice greatly appreciated
Ian
November 26, 2007 at 7:05 pm
You may want to find out that MS not only changed the name of DTS, but changed it from scratch.
You cannot do transforms under a workgroup edition.
For a better understanding read here
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Good luck
November 26, 2007 at 8:08 pm
MS really helped out with your decision in SQL Server 2005 with the Standard Edition spanning 1,2, and 4 processors. So, with two 4 processor Standard licenses (about $16k for licenses per 4 processors for a total of $32k for a two node cluster) one could have very, very fast two node cluster, running Active/Active mode, with each Intel Xeon processor having Quad cores [like a DL580 G5 from HP]. This is one extremely fast cluster for small dollars. The Enterprise version licenses alone would be closer to $160-$200k for no benefit in a two node cluster. Check out Brian Kelly's how too's for this (he is the moderator for this topic). This configuration is likely way beyond your needs, so scale down from here; I'd start with a dual processor, quad core, two node cluster. In my experience, an Active/Active configuration is the way to go as it give you failover and utilizes your hardware. We even had one with UAT on one Active side and PROD on the other. The setup for Microsoft Distributed Transaction Coordinator (MS DTC) can be a hangup - again check this site and Brian Kelly (among others) for details.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply