Converting MySql database to Postgree

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Konrad
    #1

    Converting MySql database to Postgree

    Can someone please provide me an easy and effective way to convert
    MySql database (with data included) to new Postgree database?

    Thanks,

    Konrad
    Tags: None
    • Trevor Best
      #2
      Re: Converting MySql database to Postgree

      Konrad wrote:
      [color=blue]
      > Can someone please provide me an easy and effective way to convert
      > MySql database (with data included) to new Postgree database?[/color]

      You might get better helped in the relevant newsgroup(s) :-)

      --

      \\\\\\
      \\ \\ Windows is searching
      \ \ For your sig.
      \ \ Please Wait.
      \__\

        Comment

        • Konrad Sz
          #3
          Re: Converting MySql database to Postgree



          Actually I've forgotten that conversion from Ms Access is also one that
          I'd like know, so is the place getting a bit relevant now??

          Sorry for that mistake. Next time I'll try to be more careful ;).

          Greetings

          *** Sent via Developersdex http://www.developersdex.com ***
          Don't just participate in USENET...get rewarded for it!

            Comment

            • Bernard Peek
              #4
              Re: Converting MySql database to Postgree

              In message <41528751$0$261 21$c397aba@news .newsgroups.ws> , Konrad Sz
              <konio@eranet.p l> writes[color=blue]
              >
              >
              >Actually I've forgotten that conversion from Ms Access is also one that
              >I'd like know, so is the place getting a bit relevant now??
              >
              >Sorry for that mistake. Next time I'll try to be more careful ;).[/color]

              Moving data from one back-end database to another is relatively simple.
              Create a new database and new tables with the right fields. Use ODBC to
              create linked tables in Access then use append queries to append data
              from the old table to the new one.

              That might not be the most efficient way of moving data across but it is
              probably the simplest.

              If you have forms or reports in Access you can continue to use those,
              they can use the data stored in MySQL or PostgreSQL databases.


              --
              Bernard Peek
              London, UK. DBA, Manager, Trainer & Author. Will work for money.

                Comment

                • Trevor Best
                  #5
                  Re: Converting MySql database to Postgree

                  Konrad Sz wrote:
                  [color=blue]
                  >
                  > Actually I've forgotten that conversion from Ms Access is also one that
                  > I'd like know, so is the place getting a bit relevant now??
                  >
                  > Sorry for that mistake. Next time I'll try to be more careful ;).[/color]

                  I wasn't trying to play net cop, just that you get more MySQL experts in
                  a MySQL newsgroup than in an Access one :-)


                  --

                  \\\\\\
                  \\ \\ Windows is searching
                  \ \ For your sig.
                  \ \ Please Wait.
                  \__\

                    Comment

                    Previous template Next
                    Working...