> > Q: Anyone know of any programs or methods to reliably convert the
> > database data from ms sql 2005 to PostgreSQL (or MySQL if I don't have
> > an option)? There's a LOT of data, so manually copying it is out of
> > the question.
>=20
> Update: The conversion process needs to be repeatable, so that the
> PostgreSQL database can be updated (or completely overwritten,
> whatever) from the ms sql 2005 database.
>=20
> In quite a panic right now...


I do not have much experience with MS SQL, stayed away from it as much as
possible.  But it should have an export or backup to SQL queries, which you=
 can
then execute on PG or MySQL server.  If not: it's fairly simple to write a
script (e.g. in perl, or even visual basic) that would pull data from MS SQ=
L and
put into PG. In perl, you can use ODBC connector to talk to MS SQL. =20

Sergey Dryga
http://beaglerobotics.com



--=20
http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist
.