Wednesday, March 21, 2012

Postgresql migration tool?

I have a postgres db and would like to convert to SQL Express or standard edition. Is there a conversion or migration tool available?

I can dump the postgres db to a sql file but MS has slightly different syntax and datatypes so I have to go in a manually modify the sql file for every table and data type. Is there an easier way? Thanks!

I'm not aware of any such tool from Microsoft but I've moved this thread to the database engine forum where you're more likely to find a knowledgeable answer.

Paul

No comments:

Post a Comment