export schema and stored procedures

[LucasH]

Question,

I am trying to convert a SQL Server db to a posgreSQL db (actually I am not, I am giving it to another person) and am wondering if there is a way I can export or print the schema? Relationships, table designs, data types, etc? i know about the diagram, but I don't want to have to rearrange the tables so i can print them out.

Also, i want to be able to give him the stored procedures as well. Can I export the text of each stored procedure somehow?

 

[DrSql]

You can export the schema and without data to ACCESS or, you can Digram Wizard will create a graphical schema for you. That you can export into other formats. The digram might need some tweeks depedning on the db designer has followed same naming and data formats.

Dr.Sql
Good Luck.