Re: [expert] Replacing a MS SQL Server
-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
Re: [expert] Replacing a MS SQL Server
-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
Re: [expert] Replacing a MS SQL Server
On Fri, 21 Jun 2002 20:33:41 -0400 PlugHead <[EMAIL PROTECTED]> wrote: > > > > 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
> > 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
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
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
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
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