Subject | Re: Importing data from SQL Server (null values issue) |
---|---|
Author | christian_stengel |
Post date | 2004-09-09T09:24:47Z |
Hi Avi,
transporting the content of Tables between two firebird databases.
You can lock at it unter:
http://www.lugal.de/~stummel/scripts/transport.py
As it currently works only for firebird databases, your have to change
some code for the SQL Server - but it should be a good place to start
with. The NULLs are currently convertet to "" or to 0 but your can
simply remove the code (search for None). Please don't blame me - this
is my first python script :-)
For the script your will need the kinterbasdb driver available at:
kinterbasdb.sf.net
Chris
> I need to import data from SQL Server 7.0 into a new FB 1.5.1 database.I didn't do it with SQL Server - but I wrote a Python Script for
transporting the content of Tables between two firebird databases.
You can lock at it unter:
http://www.lugal.de/~stummel/scripts/transport.py
As it currently works only for firebird databases, your have to change
some code for the SQL Server - but it should be a good place to start
with. The NULLs are currently convertet to "" or to 0 but your can
simply remove the code (search for None). Please don't blame me - this
is my first python script :-)
For the script your will need the kinterbasdb driver available at:
kinterbasdb.sf.net
Chris