SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict
    Join Date
    May 2006
    Location
    Ljubljana
    Posts
    241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    database migration // help

    Hello,

    I want to migrate my old database structure to a new one.

    The structure of the database has quite few changes like new column names, additional columns, etc. and beside that I added some other stuff like nested sets which means I should write some values with records copied to new database structure. The code is written in php.

    Is there any good tool to make my life easier when dealing with this stuff?

    Doing it by hand would be a pain.

    Thanks for help
    Get RankTrackr 2.0: Rank Tracker | PopStrap

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by l2u View Post
    Is there any good tool to make my life easier when dealing with this stuff?
    i've never seen one, although i don't doubt that they exist, and they probably have very hefty price tags

    Quote Originally Posted by l2u View Post
    Doing it by hand would be a pain.
    no it wouldn't

    all you have to do is write the correct INSERT statements using the SELECT option

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

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