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.

TIA

share

migration rejected from stackoverflow.com Jan 27 at 19:31

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by swasheck, RolandoMySQLDBA, Paul White, Mikael Eriksson, RLF Jan 27 at 19:31

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – swasheck, RolandoMySQLDBA, Paul White, Mikael Eriksson, RLF
If this question can be reworded to fit the rules in the help center, please edit the question.

2  
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