Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012
    Posts
    1

    Unanswered: Migration to postgresql

    I'm facing problem when migrating table data from SQL Server 2005 to Postgres. Is there any tool that I could use to migrate the data?

  2. #2
    Join Date
    Jul 2006
    Posts
    49
    What did you get when you searched the Internet for "migrate sql server postgres"? I got so many hits I can't count them all. Google or Bing can answer that question in a few minutes, where as posting it here could take weeks to get an answer that might not be as complete.

    Depending on the importance of your database you should consider hiring someone who specializes in this type of migration. Why? Because it can be very time consuming to migrate between systems with different data types and structures, and the end result needs to be optimized and maintainable. Banks, on-line stores, and other companies whose existence depends on their PostgreSQL database would rather hire a migration specialist with lots of experience to do the job quickly and efficiently rather than tie up their internal resources for several months and hope they do a good job. For example: does your company have a pl/pgsql expert that will rewrite your tsql so it is optimized for PostgreSQL? (Disclaimer: I am not a migration specialist and make no recommendations on who to hire.) Just a thought for your consideration.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by sumbly View Post
    I'm facing problem when migrating table data from SQL Server 2005 to Postgres.
    And which problem are you facing?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •