Thread: data migration

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    3
    Rep Power
    0

    data migration


    I want to migrate data from my postgresql version 1 to 2. My version 2 has more new tables and some more columns (old table with more new columns) Can someone give me a hint, helping hand or direction how to do this ?
    thanks
  2. #2
  3. Psycho Canadian
    Devshed Demi-God (4500 - 4999 posts)

    Join Date
    Jan 2001
    Location
    Canada
    Posts
    4,846
    Rep Power
    635
    write a scirpt that takes all the data from the first one and puts it correctly in the new one.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    3
    Rep Power
    0
    Can you be a bit more specific ? Are you refering to pl/pgsql ? Can you give me a sample of the code or pointing me to somewhere that can give me a sample of the code ?
    Thanks

IMN logo majestic logo threadwatch logo seochat tools logo