SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict Banana Man's Avatar
    Join Date
    Dec 2005
    Posts
    391
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Local database testing

    Hi,

    I'm curious what other people do with respect to the database when writing new code for a site that's already live?

    Before a site is live when im working on my local testing server i connect to a local version of my database. Once the site is live though this is not an option as i cant just download a copy of the latest live database and then upload when i am finished working on it as anything in-between on the live database would be lost. If i connect to the live database from my local testing server i cant go into my database and start editing things as it might break the live site. Im sure im missing some obvios method here?

    Thanks!

  2. #2
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,251
    Mentioned
    113 Post(s)
    Tagged
    1 Thread(s)
    If it requires a database change, I copy the database local, then write SQL scripts which can be run to make the appropriate changes. If it's a lot of changes, I'll reload the test database right before migrating to test the script to ensure it works completely.
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style


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
  •