3

I would like to migrate a SQL Server 2008 database to Postgres.

Is there a painless way to do this? are there any tools that will scan through the schema and stored procedures to flag compatibility problems?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Element
  • 3,981
  • 7
  • 42
  • 51

1 Answers1

1
  1. Painless http://dbconvert.com/convert-mssql-to-postgre-pro.php
  2. Painfull export plain schema + regex + rewrite tsql.
baklarz2048
  • 10,699
  • 2
  • 31
  • 37
  • 1
    I think a tool like that can give you a starting point. You should however still go through all your stored procedures to make sure thinks work correctly on the new database. SQL Server 2008 is not PostgreSQL and I have yet to see a conversion tool do a 100% job at understanding all the diffrences between two database systems, such as locking model. That said I have never used this tool. – Kuberchaun Oct 05 '10 at 13:40