=20

	I'd tend to disagree with you here.  MSSQL isn't 100% crap; the
code/design that the prior "developer" may have created
 could well be crap, but the MS version of SQL isn't to blame for
that. =20

	I am sure that a reasonably untalented developer could make a pigs
ear from any environment..=20
 *(I am working on one right now!)=20

	I would approach this from a slightly different angle.  Discover
what the client does / does not like about the system (apart fromt
the instablity that is).
 and redevelop the front end first..=20
 On Fri 16/12/11 12:37 AM , V G x.solarwind.x@gmail.com sent:
  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 [1] PIC/SX FAQ & list archive
 View/change your membership options at
 http://mailman.mit.edu/mailman/listinfo/piclist [2]


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