Nate,

  Use any ERD tool to reverse engineer the database into MS SQL sql. If you
get lucky, your ERD too will do Postgress.  Then you can let the ERD tool 
convert the ERD from MS SQL to Postgress, and the sql code will follow. 
Otherwise, take that sql and go over it and change the syntax to fit the
Postgress syntax.  If both Postgress and MS SQL follow the ANSI standards
pretty closely, then converting the sql should not be too bad.  I would
estiamte that you should be able to convert 70-80% with no problem.  The
rest you will have to do by hand.


On Fri, Jul 20, 2001 at 03:49:43PM -0500, Nate Carlson wrote:
> Anyone know of a way to get Microsoft SQL server to replicate a database
> to a Postgres server?
> 
> -- 
> Nate Carlson <natecars at real-time.com>   | Phone : (952)943-8700
> http://www.real-time.com                | Fax   : (952)943-8500
> 
> 
> _______________________________________________
> tclug-list mailing list
> tclug-list at mn-linux.org
> https://mailman.mn-linux.org/mailman/listinfo/tclug-list