Hi all,

I'm doing a project for a doctor whom previously employed a highly
unskilled and incompetent contractor whom used Microsoft SQL Server
2005 for a patient database. I now have to pick up the pieces and
write a program that accesses the database. The problem is, ms sql
server is 100% crap, and the visual basic program that the previous
dude wrote is even worse. The way that the database is, is very
inconvenient to use (for me as a developer) and constantly errors out,
crashes, etc on several systems I've tested, as well as in a VMware
environment. I need to convert it to PostgreSQL (or MySQL at the worst
case) as soon as possible as the doctor's patients depend upon it. I
only need to keep the table structure (column names and types (or
similar types)) and the primary and foreign keys. Functions and views
are not necessary as I can make those myself later on.

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
http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist
.