pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
product feature sets 2+ messages / 2 participants [nested] [flat]
* product feature sets @ 2004-11-17 22:56 David Bear <David.Bear@asu.edu> 2004-11-17 23:34 ` Re: product feature sets Simon Riggs <simon@2ndquadrant.com> 0 siblings, 1 reply; 2+ messages in thread From: David Bear @ 2004-11-17 22:56 UTC (permalink / raw) To: pgsql-admin This may sound like an impossible thing to ask because it may seem like an apples to oranges questions. If there were a book entitled "Using Postgresql with MS Access" I would suspect answers there. Still I'm going to draw upon the collective experience of this list. 1) are there any comparisons done between the relational features of ms-access vs postgresql? Things like, does access enforce referential integrity... triggers... transactions... etc. 2) Since Access has the upsize tool that helps converting data to an ms-sql server, has anyone made a similar tool that helps with access? I have received from this group an email with some script in it that helps with table migration but I haven't had a chance to really understand what it does -- Many thanks in advance. -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing" ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: product feature sets 2004-11-17 22:56 product feature sets David Bear <David.Bear@asu.edu> @ 2004-11-17 23:34 ` Simon Riggs <simon@2ndquadrant.com> 0 siblings, 0 replies; 2+ messages in thread From: Simon Riggs @ 2004-11-17 23:34 UTC (permalink / raw) To: David.Bear@asu.edu; +Cc: pgsql-admin On Wed, 2004-11-17 at 22:56, David Bear wrote: > This may sound like an impossible thing to ask because it may seem > like an apples to oranges questions. If there were a book entitled > "Using Postgresql with MS Access" I would suspect answers there. > > Still I'm going to draw upon the collective experience of this list. > > 1) are there any comparisons done between the relational features of > ms-access vs postgresql? Things like, does access enforce referential > integrity... triggers... transactions... etc. > There is no need. Microsoft themselves explain how Access is not suitable for use in business critical activities. PostgreSQL is comparable with SQLServer, and clearly ahead of Access DB. > 2) Since Access has the upsize tool that helps converting data to an > ms-sql server, has anyone made a similar tool that helps with access? > I have received from this group an email with some script in it that > helps with table migration but I haven't had a chance to really > understand what it does -- The upsize tool is a myth. SQLServer DBAs do not accept it, nor will they accept the poor designs of Access databases. Replicating something that exists only for marketing perceptions is not something that you'll find people spending their time on. This is the reason Access now provides "project files" that allow an Access application to work against a SQLServer database. The "Access problem" is one big reason PostgreSQL is well supported, and will continue to be so. Microsoft are responding by making SQL Server 2005 free for use on one CPU... as if that helps. -- Best Regards, Simon Riggs ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-11-17 23:34 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-11-17 22:56 product feature sets David Bear <David.Bear@asu.edu> 2004-11-17 23:34 ` Simon Riggs <simon@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox