Sql Server 2005 Enterprise Edition(Sql server community Help required0

All SQL Gurus,

We are in the exercise of planning and designing a data warehouse for
our company.

But at same time we are having a debate over which database to use
Mysql or Sql Server Ent Edition.

I'm in the favour of Sql Server due to its Gui flexible front end and
the new enhancements that have been added in the 2005 edition but I,m
required to put a white paper together for against Mysql.

I got some ideas already but would appreciate if all SQL SERVER GURUS
could give me some more points to add-on, it needs to be a strong case
as would require the company to spend a reasonable amount of cash for
about 4 processor licence.......

Swagener wrote:
> All SQL Gurus,
>
> We are in the exercise of planning and designing a data warehouse for
> our company.
>
> But at same time we are having a debate over which database to use
> Mysql or Sql Server Ent Edition.
>
> I'm in the favour of Sql Server due to its Gui flexible front end and
> the new enhancements that have been added in the 2005 edition but I,m
> required to put a white paper together for against Mysql.
>
> I got some ideas already but would appreciate if all SQL SERVER GURUS
> could give me some more points to add-on, it needs to be a strong case
> as would require the company to spend a reasonable amount of cash for
> about 4 processor licence.......
>

Choosing a database platform because of it's GUI front-end? If you're
doing things properly, you won't use the GUI for much at all, you'll be
creating and manipulating your database objects using DDL scripts, which
are safely stored in a version control archive.

You need to do a feature comparison of the two platforms. How do they
each handle recovery in case of hardware failure? How easy is it to
manage security in each? How easy is it to do ETL operations in each?


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Yes I understand that we will be using the ddl script but there will be
also work around the project which requires integration and routine
extraction where less technical staff can be utilised for project work.
Then I,m progressing slowly towards comparing the engines but I was
anticipating to get facts why Mysql is not up to speed for a enterprise
level systems.

Swagener wrote:
> Yes I understand that we will be using the ddl script but there will be
> also work around the project which requires integration and routine
> extraction where less technical staff can be utilised for project work.
> Then I,m progressing slowly towards comparing the engines but I was
> anticipating to get facts why Mysql is not up to speed for a enterprise
> level systems.
>

I think you'll find endless arguments for why one platform is better
than another. I'm sure many people would disagree with the statement
that MySQL isn't up to speed for enterprise use, but not in this group.
If a product fills your requirements and budget, then it's "up to
speed", but only you can determine that.


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com

You might want to take a look at the Kimball Group Book "The Microsoft Data
Warehouse Toolkit" by Joy Mundy and Warren Thornthwaite - yes, this is more
than a whitepaper, but it helps to see the complete picture, to "Deliver the
entire solution: DWH, Reporting, Analytics, training, support, web site,
documentation."

Among others it gives you several pages of "Why use Analysis Services?".

Analysis Services as well as Integration Services (for the ETL process to
set up the DWH) and Reporting Services come with SQL Server at no extra cost
and as far as I know there is nothing comparable in MySQL yet.

HTH, Helmut


"Swagener" <riqband@gmail.com> schrieb im Newsbeitrag
news:1157565499.760354.73420@i3g2000cwc.googlegrou ps.com...
> All SQL Gurus,
>
> We are in the exercise of planning and designing a data warehouse for
> our company.
>
> But at same time we are having a debate over which database to use
> Mysql or Sql Server Ent Edition.
>
> I'm in the favour of Sql Server due to its Gui flexible front end and
> the new enhancements that have been added in the 2005 edition but I,m
> required to put a white paper together for against Mysql.
>
> I got some ideas already but would appreciate if all SQL SERVER GURUS
> could give me some more points to add-on, it needs to be a strong case
> as would require the company to spend a reasonable amount of cash for
> about 4 processor licence.......
>