On Thu, 2011-12-15 at 19:37 -0500, V G wrote:
> 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.

Don't have direct experience, but it should be pretty simple to write a
script that issues SQL queries to one DB and writes them out to another
(or, just temporarily, writes out the data to a text file that can then
be imported by another program).

Try googling for sometime like "simple MS SQL query script". You'll just
have to mod it for the data you actually want to query. I'd aim for a
perl solution personally.

TTYL

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