On Thu, Dec 15, 2011 at 7:37 PM, V G wrote: > 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. 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. In quite a panic right now... --=20 http://www.piclist.com PIC/SX FAQ & list archive View/change your membership options at http://mailman.mit.edu/mailman/listinfo/piclist .