MySQL or PostGreSQL to go with MSSQL?

Sorry to post this here, but of course I need to give expert advice in the
next 5 minutes.
Does anyone have any experience with either of these? My company is going to
start using one of these in addition to MSSQL for long winded reasons and
they want my input as to which one to go with. I know that mysql doesnt
(yet) support Stored Procs, but is very fast. What Im really wondering about
though is stuff like...
1; Can DTS be used to import/ export data from either of these? If so, is
one easier than the other? (I dont see a connection for either in the design
DTS tool.)
2; Is one more secure than the other?
3; DB size limits for either?
4; Disaster recovery for either?
TIA, ChrisR"ChrisR" <noemail@.bla.com> wrote in message
news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
> Sorry to post this here, but of course I need to give expert advice in the
> next 5 minutes.
> Does anyone have any experience with either of these? My company is going
> to start using one of these in addition to MSSQL for long winded reasons
> and they want my input as to which one to go with. I know that MySQL
> doesnt (yet) support Stored Procs, but is very fast. What Im really
> wondering about though is stuff like...
> 1; Can DTS be used to import/ export data from either of these? If so, is
> one easier than the other? (I dont see a connection for either in the
> design DTS tool.)
> 2; Is one more secure than the other?
> 3; DB size limits for either?
> 4; Disaster recovery for either?
>
Why not MSDE or SQL Server 2005 Express Edition?
David|||Never thought about it. But if theres no GUI, one needs to be designed?
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:Og$DY6FlFHA.3656@.TK2MSFTNGP09.phx.gbl...
> "ChrisR" <noemail@.bla.com> wrote in message
> news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
> Why not MSDE or SQL Server 2005 Express Edition?
> David
>|||There are plenty of free and cheap GUI's for MSDE. Check Aarons [url]www.aspfaq.com,[/u
rl] I know he has an
article on the subject.
And, SQL Server Express ("SQL Server 2005 MSDE") will come with a basic GUI.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <noemail@.bla.com> wrote in message news:OJLdwIGlFHA.708@.TK2MSFTNGP10.phx.gbl...[vbc
ol=seagreen]
> Never thought about it. But if theres no GUI, one needs to be designed?
>
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in mes
sage
> news:Og$DY6FlFHA.3656@.TK2MSFTNGP09.phx.gbl...
>[/vbcol]|||Well, I will throw in my $0.02!
A good while back I was playing with the idea of looking into some
open-source database server options. I made a post in this news group
inquiring about the possibilities.
MySQL is a popular open-source database. They have a lot of free support
( via forums and news groups and mailing lists and what not ) and - from
what I hear - some pretty good paid support. They do offer a lot of
training. And you can find a lot of good books on MySQL. It also seems
that more and more people are catching the fever.
However, what was suggested to me was to stick with PostgreSQL. I do not
remember why ( well isn't that convenient ). I am pretty sure that it was
Aaron who made the suggestion with the reasons. Now, I am not sure if MySQL
version 5 is going to negate that suggestion.
Check in this news group about four months ago ( something like this... )
for my post.
Now, I am very sure that mysql runs on Windows. I help in some environments
where mysql is running on SBS2000. I *believe* that there is a problem with
PostgreSQL running on a Windows platform ( not really sure if the problem is
that it does not run at all or if there are some problems....sorry! Not
really a data base guy - yet! ). I am currently back on the database server
quest and playing with FreeBSD and PostgreSQL. Just waiting for the FreeBSD
CD-ROM to arrive before I can do some hands on...
Hope that this was somewhat helpful to you. It looks like you have some
pretty good answers already.
Cary W. Shultz
Roanoke, VA 24012
Microsoft Active Directory MVP
http://www.activedirectory-win2000.com
http://www.grouppolicy-win2000.com
"ChrisR" <noemail@.bla.com> wrote in message
news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
> Sorry to post this here, but of course I need to give expert advice in the
> next 5 minutes.
> Does anyone have any experience with either of these? My company is going
> to start using one of these in addition to MSSQL for long winded reasons
> and they want my input as to which one to go with. I know that MySQL
> doesnt (yet) support Stored Procs, but is very fast. What Im really
> wondering about though is stuff like...
> 1; Can DTS be used to import/ export data from either of these? If so, is
> one easier than the other? (I dont see a connection for either in the
> design DTS tool.)
> 2; Is one more secure than the other?
> 3; DB size limits for either?
> 4; Disaster recovery for either?
>
> TIA, ChrisR
>|||"Cary Shultz [A.D. MVP]" <cwshultz@.mvps.org> glsD:OF6Lm%23GlFHA.3656@.TK2MSFTNG
P09.phx.gbl...
> I *believe* that there is a problem with PostgreSQL running on a Windows
> platform ( not really sure if the problem is that it does not run at all
> or if there are some problems....sorry! Not really a data base guy -
> yet! ).
Yes. There is also a severe performance issue if PostgreSQL is running in
Windows platform too.
So you'd better use *nix system if you want to use it.|||At one time, to run PostgreSQL under Windows you had to use the Cygwin Unix
emulation library, but there is now a native Windows port for PostgreSQL
8.0.
"Cary Shultz [A.D. MVP]" <cwshultz@.mvps.org> wrote in message
news:OF6Lm%23GlFHA.3656@.TK2MSFTNGP09.phx.gbl...
> Well, I will throw in my $0.02!
> A good while back I was playing with the idea of looking into some
> open-source database server options. I made a post in this news group
> inquiring about the possibilities.
> mysql is a popular open-source database. They have a lot of free support
> ( via forums and news groups and mailing lists and what not ) and - from
> what I hear - some pretty good paid support. They do offer a lot of
> training. And you can find a lot of good books on MySQL. It also seems
> that more and more people are catching the fever.
> However, what was suggested to me was to stick with PostgreSQL. I do not
> remember why ( well isn't that convenient ). I am pretty sure that it was
> Aaron who made the suggestion with the reasons. Now, I am not sure if
> mysql version 5 is going to negate that suggestion.
> Check in this news group about four months ago ( something like this... )
> for my post.
> Now, I am very sure that mysql runs on Windows. I help in some
> environments where mysql is running on SBS2000. I *believe* that there is
> a problem with PostgreSQL running on a Windows platform ( not really sure
> if the problem is that it does not run at all or if there are some
> problems....sorry! Not really a data base guy - yet! ). I am currently
> back on the database server quest and playing with FreeBSD and PostgreSQL.
> Just waiting for the FreeBSD CD-ROM to arrive before I can do some hands
> on...
> Hope that this was somewhat helpful to you. It looks like you have some
> pretty good answers already.
> --
> Cary W. Shultz
> Roanoke, VA 24012
> Microsoft Active Directory MVP
> http://www.activedirectory-win2000.com
> http://www.grouppolicy-win2000.com
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:eMDkZ0FlFHA.3968@.tk2msftngp13.phx.gbl...
>