Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a fairly simple SQL Server 2005 schema that I exported to a tSQL file.

I am looking for a tool, preferably open source and runs on Win 7 (Ubuntu 2nd choice) that will convert the transact SQL schema to PostgreSQL psql that I can use to duplicate the database structure in PostgreSQL 9.2

I need to generate about 15 tables with autoinc PK's numerous FK relationships, some simple storedprocs and triggers.

Data replication is NOT necessary.


share|improve this question

migrated from stackoverflow.com Oct 8 '12 at 14:24

This question came from our site for professional and enthusiast programmers.

For 15 tables: just do the typing. As a side effect, you'll learn about the subtle differences. –  wildplasser Oct 3 '12 at 9:34
Probably right about just doing the typing. I generally do it at night when I'm tired so I'm looking for a tool - but maybe I should just do it - already done a few tables. –  Vector Oct 3 '12 at 17:29
Mahmoud - just put it on DBAS. –  Vector Oct 3 '12 at 17:36

1 Answer 1

up vote 1 down vote accepted

here is the simple document where you can find tsql to postgresql

to know more about ms-sql to postgresql here

tools : ESF Database Migration Toolkit and db-convert

share|improve this answer
Thanks - good references on converting. Would you happen to know if the trial version of ESF will allow me to do my small job without paying for the whole product, which I REALLY don't need? If it's a question of paying $200+ I will type it myself. –  Vector Oct 3 '12 at 17:27
yes you can, mostly that allow only few no.of table. –  sola Oct 4 '12 at 3:52

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.