Do you know if something equivalent to the "DTM Migration Kit" you
mentioned exists as open software? Using a commercial product is not
very practical in my case, because the clients would have to agree on
buying it, which I belive is not likely.
Have you considered migrating the data from MSSQL to Postgres? We ran
into the same problem you are having, and purchased the "DTM Migration
Kit". http://www.sqledit.com/mk/index.html
This tool lets you do arbitrary sql on migration, so if the MSSQL
database is being used by another app, you
> Have you tried this?
> http://www.egenix.com/files/python/mxODBC.html
>
> For commercial use you might have to pay for it but should run on Linux.
true, and that's why I don't like it very much :) haven't tried it,
though it seems to have a large user base, so I suppose it's built
right.
>
Hi Filipe,Have you tried this?http://www.egenix.com/files/python/mxODBC.htmlFor commercial use you might have to pay for it but should run on Linux.
There is also this one (SWIG based):https://sourceforge.net/projects/pyodbI cannot say anything about any of them, at work I'm forcedĀ to use Windows
FreeTDS is indeed the the library used by Pymssql, but only in Linux.
For me there's one big disadvantage with pymssql, it has far too many
limitations under windows (it uses DB-Library under windows), which
makes it not a real cross-platform solution. Yet, I'm using it for
connection to MSSql
Jeremy Dunck wrote:
> On 7/15/06, dan <[EMAIL PROTECTED]> wrote:
> >
> > I need to access MS SQL Server from our Linux host. Is there currently
> > a way to do this? If not, any idea how many hours it would take an
> > experienced programmer to add it? And what would be the best way? ODBC?
> > I