MS SQL Server

[Steve Holden]

"Ben" <b.e.n. at .r.e.h.a.m.e...c.o.m> wrote in ...
> Hi,
>
> Unfortunately I have to upload data to a MS SQL server ... Can anyone
> recommend a tool for doing this or docs\examples :]  ... is it ANSI
> SQL compliant like MySQL and therefore can use the same commands?
>
> greatly appreciate any advice
>
Ben:

The easiest way (assuming you have the ability to connect to both databases
from Python, otherwise this would be an off-topic post, woudn't it ;-) is to
do the whole thing in Python.

You don't make it clear whether the data is coming from other relational
sources or from somewhere else. THe principle is the same in either case,
however.

SQL Server is (like most relational systems) ANSI compliant at the lowest
level. Fortunately, since all you need to use is the INSERT statement, this
should be enough.

ODBC is the easiest way to connect to SQL Server, but look at using mxODBC
rather than the currently-disfunctional odbc module form the win32
extensions.

Hope this helps.

regards
 Steve
--
http://www.holdenweb.com/