RE: MSSQL to ???? Linux (new question)

2002-01-28 Thread Robert Finneran
EMAIL PROTECTED]Subject: Re: MSSQL to Linux (new question) Is it only possible to first make a DB in MSSQL and then exporting it toMySQL or PostgreSQL, or can i also build an MSSQL compatible DB fromscratch?I'm asking this because we're gonna upgrade our bookkeeping pr

Re: MSSQL to ???? Linux (new question)

2002-01-28 Thread Patrick Lankhorst
Is it only possible to first make a DB in MSSQL and then exporting it toMySQL or PostgreSQL, or can i also build an MSSQL compatible DB fromscratch?I'm asking this because we're gonna upgrade our bookkeeping program to awindows version (it's only DOS now) and that new program can only functi

Re: MSSQL to ???? Linux

2002-01-10 Thread Jonathan Bartlett
> I have a customer that has finaly gotten sick of MS NT and SQL and would > like to move it to Linux. Has anyone ever done this and what does it take > ? I haven't done this, but here are a few ideas: 1) Does it used stored procedures? If so, they will have to be rewritten, and it could tak

Re: MSSQL to ???? Linux

2002-01-10 Thread Cameron Simpson
On 13:12 10 Jan 2002, Chris Bond <[EMAIL PROTECTED]> wrote: | > I don't know what you mean by 'Stored Procedures', but PostgreSQL does | > support server run procedures in PL/SQL, tcl, C, perl and maybe others | that | > run inside the server, and can be called directly in SQL or can be called | a

RE: MSSQL to ???? Linux

2002-01-10 Thread Robert Finneran
AM To: [EMAIL PROTECTED] Subject: Re: MSSQL to Linux This is very good question are they any sql servers out there that support stored procedures, so far mysql and postgres dont. If they we to implement that feature and do a login auth for mssql, so many people would switch to it because

RE: MSSQL to ???? Linux

2002-01-10 Thread Needham, Douglas
To begin with doing a database migration from one platform to another is NOT a simple task. (unless it is a very simple database) Postgresql is a very good database. Red Hat uses this for their Red Hat Database product. Mysql is also very good. They are targeted at different audiences tho. Yo

Re: MSSQL to ???? Linux

2002-01-10 Thread Francisco Neira
A time ago I read at the MySQL TODO that they will not plan to implement Stored Procedures or triggers because this will slow down the engine's performance. Francisco ___ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman

Re: MSSQL to ???? Linux

2002-01-10 Thread Gary Stainburn
On Thursday 10 January 2002 1:12 pm, Chris Bond wrote: > > I don't know what you mean by 'Stored Procedures', but PostgreSQL does > > support server run procedures in PL/SQL, tcl, C, perl and maybe others > > that > > > run inside the server, and can be called directly in SQL or can be called > >

Re: MSSQL to ???? Linux

2002-01-10 Thread Chris Bond
Is it going to be implemented in any free database software like mysql, postgres etc though? - Original Message - From: "Francisco Neira" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 10, 2002 1:12 PM Subject: Re: MSSQL to Linux > I

Re: MSSQL to ???? Linux

2002-01-10 Thread Dave Ihnat
On Thu, Jan 10, 2002 at 01:12:49PM -, Chris Bond wrote: > A Stored Procedure is a microsoft thing, its a server side procedure that > can be cached for permformance reasons - heres an example: Uh. Ahem. Deepest apologies, but Microsoft swiped it from other database systems, such as Sybase o

Re: MSSQL to ???? Linux

2002-01-10 Thread Francisco Neira
I am not a DBA either, but AFAIK Sybase Anywhere, Sybase Adaptive and Oracle 8 use stored procedures too. Regards Francisco ___ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list

Re: MSSQL to ???? Linux

2002-01-10 Thread Chris Bond
> I don't know what you mean by 'Stored Procedures', but PostgreSQL does > support server run procedures in PL/SQL, tcl, C, perl and maybe others that > run inside the server, and can be called directly in SQL or can be called as > triggers. I've had a little look at it and it does look good. A

Re: MSSQL to ???? Linux

2002-01-10 Thread Gary Stainburn
On Thursday 10 January 2002 8:56 am, Chris Bond wrote: > This is very good question are they any sql servers out there that support > stored procedures, so far mysql and postgres dont. If they we to implement > that feature and do a login auth for mssql, so many people would switch to > it becau

Re: MSSQL to ???? Linux

2002-01-10 Thread Chris Bond
This is very good question are they any sql servers out there that support stored procedures, so far mysql and postgres dont. If they we to implement that feature and do a login auth for mssql, so many people would switch to it because sql licenses can cost 4000GBP on a large site. Kind Regards

Re: MSSQL to ???? Linux

2002-01-09 Thread Enrique Bory Simon
gain it. thank a lot - Original Message - From: "Brian Ashe" <[EMAIL PROTECTED]> To: "Scott Skrogstad" <[EMAIL PROTECTED]> Sent: Wednesday, January 09, 2002 8:47 PM Subject: Re: MSSQL to Linux > Hello Scott, > > Wednesday, January 09, 2002

Re: MSSQL to ???? Linux

2002-01-09 Thread Brian Ashe
Hello Scott, Wednesday, January 09, 2002, 10:11:49 PM, you textually orated: SS> I have a customer that has finaly gotten sick of MS NT and SQL and would SS> like to move it to Linux. Has anyone ever done this and what does it take SS> ? PostgreSQL is a superior Open Source SQL Server. You c

RE: MSSQL to ???? Linux

2002-01-09 Thread Robert Finneran
Sorry, your question is rather vague. You can run anywhere from an expensive database from IBM or Oracle or you can use an opensource solutions. Check out www.postgresql.org for PostgreSQL. IMHO it's the best open-source DB out there. We use it on many of our projects By the way, what's your tr

Re: MSSQL to ???? Linux

2002-01-09 Thread Cameron Simpson
On 21:11 09 Jan 2002, Scott Skrogstad <[EMAIL PROTECTED]> wrote: | I have a customer that has finaly gotten sick of MS NT and SQL and would | like to move it to Linux. Has anyone ever done this and what does it take The easy way is: install MySQL (redhat comes with it) install