[DB-SIG] Python to SQL Server
Mark Matthews
mem at object-craft.com.au
Tue Jun 10 11:49:59 CEST 2008
On 10/06/2008, at 7:40 PM, M.-A. Lemburg wrote:
> On 2008-06-10 03:18, Mark Matthews wrote:
>> Hello,
>> I have a client that we have built a Python-PostgreSQL-Linux
>> solution for. It works well, very stable, robust ...
>> However, they are a little keen on Microsoft products and are
>> enquiring about migrating to SQL Server (database only, leaving the
>> app running on Linux with Python)
>> I am assuming the best way forward is mxODBC. Has anyone got any
>> better ideas on how to do this. Note that it must be very stable
>> and robust - this is the operations system in a finance company
>
> If you want to connect to SQL Server from a Linux box, the best way
> to do this is to use a commercial ODBC driver such as the one from
> EasySoft and then talk to it via mxODBC.
>
> You could also use the free FreeTDS ODBC driver, but it's not really
> production quality and we don't recommend using it for mission
> critical applications.
>
> BTW: We'll also announce a new product this week which works much
> like a bridge and avoids having to find an ODBC driver for client
> application platform. It's still in beta, but we expect the final
> release by the end of the month.
Hello
Thank you for the prompt response. I had been looking at EasySoft, but
was hoping that there were alternatives.
I am *very* keen to test your product. Even thought I am not convinced
that the client will migrate a stable production system, they do have
other SQL Server databases that we extract data from (FreeTDS - which
we know to not be production quality).
--
Mark Matthews
http://www.object-craft.com.au
More information about the DB-SIG
mailing list