Re: [expert] Replacing a MS SQL Server

2002-06-23 Thread daRcmaTTeR

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Tom Badran wrote:
| On Saturday 22 Jun 2002 6:29 am, Damian G wrote:
|
|however, i don't find anywhere ( not in the OpenOffice frontend
|nor in Webmin interface to databases ) any info about setting
|foreign keys? i'm beginning to wonder do these exist in MySQL?
|
|
| Foreign keys are references, and in postgres are actually done by
using the
| keyword references, so maybe it is the same in mysql.
|
| Tom

actually, the current stable release of MySQL does not support foriegn
keys as yet. They are working on getting this into the 4.0.x release of
MySQL.

Mark
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE9FngBJuZ1geTzHgERAowbAJ90NCIBTNwzvDr20GDKSsOlnBQPBACg5w+l
Ku5PBLJZyaiIYE3rGTW4VtA=
=aG08
-END PGP SIGNATURE-




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



[expert] Replacing a MS SQL Server

2002-06-21 Thread Bob [EMAIL PROTECTED]

Hello,

I've got a client who has a Windows app that runs ODBC connections to a file server.  
The software company wants the client to set up a MS SQL server to supposedly fix the
problems we are having.  I'm a little familiar with MySQL, but is it a direct drop-in 
replacement for MS' product?  I need connectivity to Win2k workstations.  Ideas?

Bob



Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



Re: [expert] Replacing a MS SQL Server

2002-06-21 Thread Jerry Kreps

On Friday 21 June 2002 01:08 pm, [EMAIL PROTECTED] wrote:
 Hello,

 I've got a client who has a Windows app that runs ODBC connections to a
 file server.  The software company wants the client to set up a MS SQL
 server to supposedly fix the problems we are having.  I'm a little familiar
 with MySQL, but is it a direct drop-in replacement for MS' product?  I need
 connectivity to Win2k workstations.  Ideas?

 Bob

IMO, PostgreSQL is a better, more powerful RDBMS, that includes transaction 
tracking, commit and rollback, inheritance, etc   It includes a lot of 
features that MySQL only has useless stubs for.  The stubs only maintain 
'compatibility' with ANSI standards by not blowing up if a script tries to 
use them.

You won't find a 'drop-in' replacement for MS SQL (it's propriatary, including 
formats), but IF you can export our of your old system to a tab delimited or 
CVS file,  then you can import into PostgreSQL.

-- 
JLK



Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



Re: [expert] Replacing a MS SQL Server

2002-06-21 Thread J. Craig Woods

Jerry Kreps wrote:
 
 On Friday 21 June 2002 01:08 pm, [EMAIL PROTECTED] wrote:
  Hello,
 
  I've got a client who has a Windows app that runs ODBC connections to a
  file server.  The software company wants the client to set up a MS SQL
  server to supposedly fix the problems we are having.  I'm a little familiar
  with MySQL, but is it a direct drop-in replacement for MS' product?  I need
  connectivity to Win2k workstations.  Ideas?
 
  Bob
 
 IMO, PostgreSQL is a better, more powerful RDBMS, that includes transaction
 tracking, commit and rollback, inheritance, etc   It includes a lot of
 features that MySQL only has useless stubs for.  The stubs only maintain
 'compatibility' with ANSI standards by not blowing up if a script tries to
 use them.
 
 You won't find a 'drop-in' replacement for MS SQL (it's propriatary, including
 formats), but IF you can export our of your old system to a tab delimited or
 CVS file,  then you can import into PostgreSQL.
 

I would have to ditto what Jerry has stated here. If it is an enterprise
solution you seek for your RDBMS, MySQL most likely will come up a bit
short. Having worked with both MS SQL and Oracle, PostgreSQL is about
the only open source database that will come close to meeting your
needs. You can, however, look at Oracle 8i. There is a free version for
Linux. I forget where I downloaded the bin from but a search on google
should reveal something.

drjung

-- 
J. Craig Woods
UNIX/NT Network/System Administration
http://www.trismegistus.net/resume.html
Character is built upon the debris of despair --Emerson



Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



Re: [expert] Replacing a MS SQL Server

2002-06-21 Thread Jerry Kreps

On Friday 21 June 2002 04:16 pm, J. Craig Woods wrote:
 Jerry Kreps wrote:
  On Friday 21 June 2002 01:08 pm, [EMAIL PROTECTED] wrote:
   Hello,
  
   I've got a client who has a Windows app that runs ODBC connections to a
   file server.  The software company wants the client to set up a MS SQL
   server to supposedly fix the problems we are having.  I'm a little
   familiar with MySQL, but is it a direct drop-in replacement for MS'
   product?  I need connectivity to Win2k workstations.  Ideas?
  
   Bob
 
  IMO, PostgreSQL is a better, more powerful RDBMS, that includes
  transaction tracking, commit and rollback, inheritance, etc   It
  includes a lot of features that MySQL only has useless stubs for.  The
  stubs only maintain 'compatibility' with ANSI standards by not blowing up
  if a script tries to use them.
 
  You won't find a 'drop-in' replacement for MS SQL (it's propriatary,
  including formats), but IF you can export our of your old system to a tab
  delimited or CVS file,  then you can import into PostgreSQL.

 I would have to ditto what Jerry has stated here. If it is an enterprise
 solution you seek for your RDBMS, MySQL most likely will come up a bit
 short. Having worked with both MS SQL and Oracle, PostgreSQL is about
 the only open source database that will come close to meeting your
 needs. You can, however, look at Oracle 8i. There is a free version for
 Linux. I forget where I downloaded the bin from but a search on google
 should reveal something.

 drjung

It's getting harder and harder to find.   A couple of years ago I was able to 
download it and some assciated apps, like Tora, which is similar to Toad, but 
not as good.  Oracle 8i is a difficult install and requires specific versions 
RH libraries that may (?) be available from the RH website.   If he'll email 
me privately I'll send him my address, to which he can mail a self-addressed 
and appropriately stamped CD mailer. 
JLK 

-- 
JLK



Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



Re: [expert] Replacing a MS SQL Server

2002-06-21 Thread Michael Viron

Oracle 8i for linux is available from
http://otn.oracle.com/software/products/oracle8i/htdocs/linuxsoft.html

Oracle 9i is also available for linux at
http://otn.oracle.com/software/products/oracle9i/htdocs/linuxsoft.html .

Michael

--
Michael Viron
Project Manager / Primary Developer / Manager of Online Operations
General Education Online
http://www.findaschool.org

At 07:16 PM 6/21/2002 -0500, Jerry Kreps wrote:
On Friday 21 June 2002 04:16 pm, J. Craig Woods wrote:
 Jerry Kreps wrote:
  On Friday 21 June 2002 01:08 pm, [EMAIL PROTECTED] wrote:
   Hello,
  
   I've got a client who has a Windows app that runs ODBC connections to a
   file server.  The software company wants the client to set up a MS SQL
   server to supposedly fix the problems we are having.  I'm a little
   familiar with MySQL, but is it a direct drop-in replacement for MS'
   product?  I need connectivity to Win2k workstations.  Ideas?
  
   Bob
 
  IMO, PostgreSQL is a better, more powerful RDBMS, that includes
  transaction tracking, commit and rollback, inheritance, etc   It
  includes a lot of features that MySQL only has useless stubs for.  The
  stubs only maintain 'compatibility' with ANSI standards by not blowing up
  if a script tries to use them.
 
  You won't find a 'drop-in' replacement for MS SQL (it's propriatary,
  including formats), but IF you can export our of your old system to a tab
  delimited or CVS file,  then you can import into PostgreSQL.

 I would have to ditto what Jerry has stated here. If it is an enterprise
 solution you seek for your RDBMS, MySQL most likely will come up a bit
 short. Having worked with both MS SQL and Oracle, PostgreSQL is about
 the only open source database that will come close to meeting your
 needs. You can, however, look at Oracle 8i. There is a free version for
 Linux. I forget where I downloaded the bin from but a search on google
 should reveal something.

 drjung

It's getting harder and harder to find.   A couple of years ago I was able
to 
download it and some assciated apps, like Tora, which is similar to Toad,
but 
not as good.  Oracle 8i is a difficult install and requires specific
versions 
RH libraries that may (?) be available from the RH website.   If he'll email 
me privately I'll send him my address, to which he can mail a self-addressed 
and appropriately stamped CD mailer. 
JLK 

-- 
JLK

Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



Re: [expert] Replacing a MS SQL Server

2002-06-21 Thread PlugHead

snip
  You can, however, look at Oracle 8i. There is a free version for
  Linux. I forget where I downloaded the bin from but a search on google
  should reveal something.
 
  drjung

 It's getting harder and harder to find.   A couple of years ago I was able
 to download it and some assciated apps, like Tora, which is similar to
 Toad, but not as good.  Oracle 8i is a difficult install and requires
 specific versions RH libraries that may (?) be available from the RH
 website.   If he'll email me privately I'll send him my address, to which
 he can mail a self-addressed and appropriately stamped CD mailer.
 JLK

Personally, I've found that PostgreSQL is _MUCH_ easier to deal with (install, 
maintain, you name it...) than Oracle 8i.  (Of course, I don't 
want/need/give-a-rat's-a** about MS SQL compatibility, so YMMV...)

(Oh, yeah.  I'm pretty sure that Oracle is free for _development_ _only_...)

Just my .02...
-Jason
 

=
FOUR QUEENS. HMM. THAT IS VERY HIGH.
Death looked down at his cards, and then up into Granny's steady, blue-eyed 
gaze.
Neither moved for some time.
Then Death laid the hand on the table.
I LOSE, he said. ALL I HAVE IS FOUR ONES.
(Maskerade)




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



Re: [expert] Replacing a MS SQL Server

2002-06-21 Thread Damian G

On Fri, 21 Jun 2002 20:33:41 -0400
PlugHead [EMAIL PROTECTED] wrote:

 snip
   You can, however, look at Oracle 8i. There is a free version for
   Linux. I forget where I downloaded the bin from but a search on google
   should reveal something.
  
   drjung
 
  It's getting harder and harder to find.   A couple of years ago I was able
  to download it and some assciated apps, like Tora, which is similar to
  Toad, but not as good.  Oracle 8i is a difficult install and requires
  specific versions RH libraries that may (?) be available from the RH
  website.   If he'll email me privately I'll send him my address, to which
  he can mail a self-addressed and appropriately stamped CD mailer.
  JLK
 
 Personally, I've found that PostgreSQL is _MUCH_ easier to deal with (install, 
 maintain, you name it...) than Oracle 8i.  (Of course, I don't 
 want/need/give-a-rat's-a** about MS SQL compatibility, so YMMV...)
 
 (Oh, yeah.  I'm pretty sure that Oracle is free for _development_ _only_...)
 
 Just my .02...
 -Jason
  
 

.. uhm i've begun to read a bit on MySQL since i feel i should
learn about databases a bit.. 
i've had a little visual contact with MS-SQL server 7, and then
when i finally got MySQL running with OOo as frontend i had little
trouble getting started. 

however, i don't find anywhere ( not in the OpenOffice frontend
nor in Webmin interface to databases ) any info about setting
foreign keys? i'm beginning to wonder do these exist in MySQL?

can anybody enlighten me, plz? 

TIA 

Damian



Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com



Re: [expert] Replacing a MS SQL Server

2002-06-21 Thread Tom Badran

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Saturday 22 Jun 2002 6:29 am, Damian G wrote:
 however, i don't find anywhere ( not in the OpenOffice frontend
 nor in Webmin interface to databases ) any info about setting
 foreign keys? i'm beginning to wonder do these exist in MySQL?

Foreign keys are references, and in postgres are actually done by using the 
keyword references, so maybe it is the same in mysql.

Tom

- -- 
Tom Badran - Imperial College, Department of Computing
Email: [EMAIL PROTECTED] || Jabber: [EMAIL PROTECTED]
- --
cassandra.no-ip.org - Linux Kernel 2.4.18 + Preempt + ppSCSI
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE9E2UJXCpWOla2mCcRAkF/AKDXV4miix60tn9UbcIiUZZY8kHVzgCgxg7E
X66/9qXR9qUUADDEWIR4b2Y=
=yLEF
-END PGP SIGNATURE-




Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com