Le Lundi 18 Mars 2002 22:53, Dale Anderson a écrit : > A couple of our developers, which are Microsoft VB developers, are > complaining about not being able to use proprietary MS stuff with > PostgreSQL.
Dear Dale, Maybe you could consider using pgAdmin2 (http://pgadmin.postgresql.org), which displays all database objects (tables, views, functions, triggers, rules, etc...) in a nice Window$ interface. An MS SQL Server migration wizard is also included. Historically, several pgAdmin2 developpers come from an microsoft-oracle background and wanted to get out of the matrix. The most visible difference between MS SQL Server and PostgreSQL is that MS SQL Server can be programmed in VB, whereas PostgreSQL supports serveral server-side languages : PLpgSQL, PLperl, PLpython, even C... People usually underestimate the power of server-side scripting. Oracle does not and sell each server-side programming "cartridge" separately. PostgreSQL provides them for free. Furthermore, pgAdmin2 is provided with an abstraction layer called pgSchema, which gives access to most database objects through an OCX technology. pgSchema can be used in any VB project very easilly. Therefore, in my humble opinion, PostgreSQL provides a very reliable solution for both client-side (VB) and server-side (PostgreSQL) programming needs. The power of PostgreSQL is to be able to do things smartly because we offer a complete development environment. The only thing your developpers need is to install pgAdmin2 and start learning a server-side language (like PLpgSQL which is very easy). There is probably a lot of client-code in you applications to migrate server-side. PostgreSQL is also a great community of developpers. For help, the best place are pgsql-admin, pgsql-general and pgadmin-hackers mailing lists. Best regards, Jean-Michel POURE ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
