Re: [GENERAL] FileMakerPro to postgreSQL

2006-09-19 Thread brew
[EMAIL PROTECTED] writes: ... My biggest concern is the existing FileMakerPro clients. How much work would it be to connect the existing FMP clients to the postgreSQL database using ODBC? Is this a viable temporary step or could it be permanent? And Tom Lane replies: If they can

[GENERAL] FileMakerPro to postgreSQL

2006-09-17 Thread brew
I have to update a database system and need some advice. Most of the database work I've done up to now has been databased backed websites, using perl and/or php to connect to mSQL, mySQL, or postgreSQL. One job that I inherited a few years ago was actually two separate databases, one an

Re: [GENERAL] FileMakerPro to postgreSQL

2006-09-17 Thread Tom Lane
[EMAIL PROTECTED] writes: ... My biggest concern is the existing FileMakerPro clients. How much work would it be to connect the existing FMP clients to the postgreSQL database using ODBC? Is this a viable temporary step or could it be permanent? If they can speak ODBC, then in theory you can

Re: [GENERAL] FileMakerPro to postgreSQL

2006-09-17 Thread Shane Ambler
Yes filemaker can use ODBC but not as a live data source as you would use access as a frontend. You can use ODBC to import the data to a Filemaker database and display/edit it there and then export back through ODBC. If they use Filemaker to enter all the data (none is entered from the web site)