Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011-01-25 Thread Gary Chambers
I recommend dbWrench as a diagramming tool for Postgres. I can also recommend SchemaSpy (http://schemaspy.sourceforge.net/), a superb command line-based schema browser and ERD generator. -- Gary Chambers -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to y

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011-01-25 Thread Dmitriy Igrishin
2011/1/25 Jasen Betts > On 2011-01-20, Robert Paresi wrote: > > Hello, > > > > We have 700 user install base using Sybase SQL Anywhere 9.02 > > > > We are looking at migrating these installations over to PostGres > > > 1. Very Very Short Answer Please - why should we? > > postgres is the best d

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011-01-25 Thread Robert Paresi
I hear there are several, But I can't understand why someone would want to perform non-graphical tasks using a GUI. Because it is easier. I've managed to do everything I need - as well as write a full query editor/report writer for PostGreSQL. It is being beta tested now, and I plan on relea

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011-01-25 Thread Jasen Betts
On 2011-01-20, Robert Paresi wrote: > Hello, > > We have 700 user install base using Sybase SQL Anywhere 9.02 > > We are looking at migrating these installations over to PostGres > 1. Very Very Short Answer Please - why should we? postgres is the best database in the universe. :) > 2. Does an

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011-01-21 Thread Vick Khera
On Fri, Jan 21, 2011 at 3:16 AM, Uwe Schroeder wrote: > Have to say: here you get a premium product at cost of zip, nada, nothing and > when you shout out to the mailing list - and you provide useable information - > chances are you'll get premium support from people like Tom Lane. No company I >

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011-01-21 Thread Uwe Schroeder
> Hi, > > Price and features. There are some changes in V12 which is causing us to > do some steps with our support and resellers. We've always wanted to move > away from Sybase so we can make more of a profit off our software and lower > costs for us and our clients. Sybase is a wonderful p

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011-01-20 Thread Craig Ringer
On 01/21/2011 05:10 AM, Robert Paresi wrote: Price and features. There are some changes in V12 which is causing us to do some steps with our support and resellers. We've always wanted to move away from Sybase so we can make more of a profit off our software and lower costs for us and our clients

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011-01-20 Thread Robert Paresi
Hi, Price and features. There are some changes in V12 which is causing us to do some steps with our support and resellers. We've always wanted to move away from Sybase so we can make more of a profit off our software and lower costs for us and our clients. Sybase is a wonderful product, an

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011-01-20 Thread Michael Gould
Robert, We used Data Manager from JP to do this. Worked well. He recently added the ability to read OEM versions of ASA. How's come your moving away from SQL Anywhere? Best Regards Mike Gould "Robert Paresi" wrote: > Hello, > > We have 700 user install base using Sybase SQL Anywhere 9.02 >

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011-01-20 Thread Joshua D. Drake
On Thu, 2011-01-20 at 11:37 -0500, Robert Paresi wrote: > Hello, > > We have 700 user install base using Sybase SQL Anywhere 9.02 > > We are looking at migrating these installations over to PostGres > > 1. Very Very Short Answer Please - why should we? * Lower TCO * More flexibility * A growin

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011-01-20 Thread Andy Colson
On 1/20/2011 10:37 AM, Robert Paresi wrote: Hello, We have 700 user install base using Sybase SQL Anywhere 9.02 We are looking at migrating these installations over to PostGres 1. Very Very Short Answer Please - why should we? You should not. Does not sound like you have a problem to solve.

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011-01-20 Thread Chris Browne
"Robert Paresi" writes: > Hello, > > We have 700 user install base using Sybase SQL Anywhere 9.02 > > We are looking at migrating these installations over to PostGres > > 1. Very Very Short Answer Please - why should we? Cheaper? Perhaps faster? It's tough to guess, absent of metrics as to why

[GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011-01-20 Thread Robert Paresi
Hello, We have 700 user install base using Sybase SQL Anywhere 9.02 We are looking at migrating these installations over to PostGres 1. Very Very Short Answer Please - why should we? 2. Does anyone have a utility or migration application to read SQL Anywhere to go to PostGres 3. Does Pos