SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2005
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Keeping databases in sync within a team

    Hey guys.... I'm working within a team of other programmers & whenever one of us make changes to the database we usually send out an email to all other developers to make the change in their database, problem is people are getting behind on their emails & then when new code is put into a testing environment it is commonly breaking because someone forgot to make the necessary database changes.

    So I was wondering what you guys use to handle this? Is their any kind of software that would make handling stuff like this easier? Any other ideas?

    Thanks all!

  2. #2
    SitePoint Zealot
    Join Date
    Nov 2008
    Posts
    172
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'd say the use of an online workspace might come in handy. Tasks such as chat, email, hour logging, scheduling, etc could be done. As well as post new DB structures to the group. Though I suppose if they are not checking e-mails to see if there are updates / not sending emails to update everyone else, this wouldn't help at all... nor would any other solution short of everyone using the same online DB.

  3. #3
    Serial Entrepreneur
    Join Date
    Jul 2007
    Location
    Atlanta, GA
    Posts
    495
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I gotta make a HUGE shout-out here to one of my favorite tools: SQL Examiner Pro from Tulasoft. I have numerous remote SQL Server databases that I have to manage and keep in sync with my development databases and the suite is really great for that. And the price is quite good compared to their competitors.
    FreelanceLocalTech - FREE Freelance Consultant Directory!
    VersaReports Universal Report Server for .Net - Try It Now!

  4. #4
    SitePoint Enthusiast
    Join Date
    Apr 2005
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks guys... we actually have started looking at MySQL Workbench.... not sure how this compares to SQL Examiner Pro yet though. Thanks for the suggestion!

  5. #5
    Serial Entrepreneur
    Join Date
    Jul 2007
    Location
    Atlanta, GA
    Posts
    495
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by cyphix View Post
    Thanks guys... we actually have started looking at MySQL Workbench.... not sure how this compares to SQL Examiner Pro yet though. Thanks for the suggestion!
    SQL Examiner is for SQL Server sync'ing only, although you can use it to move some databases between server types. I don't have a solution for mySQL database sync'ing, although with several of those being managed, I'll likely start looking for one soon enough! I looked at workbench for a few minutes, but the free version seemed like more of a design tool, but maybe the commercial version is better for sync'ing.
    FreelanceLocalTech - FREE Freelance Consultant Directory!
    VersaReports Universal Report Server for .Net - Try It Now!

  6. #6
    SitePoint Enthusiast
    Join Date
    Apr 2005
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  7. #7
    SitePoint Member
    Join Date
    Feb 2009
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Trac ? trac-edgewall-org. The best software to track code changes, time spent on projects, has built-in wiki, etc.

    Take care,

    Mooze

  8. #8
    SitePoint Enthusiast
    Join Date
    Apr 2005
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the suggestion... will check it out!


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
  •