Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am interested in a free and simple MySQL tool which can offer online collaboration functionality in creating database general schema. Do you know any?

share|improve this question
1  
related stackoverflow.com/questions/2518277/… –  Unreason Oct 31 '11 at 12:30
    
that question has 1 year old, I am interested in more recent solutions if there are and you know some of. –  Ek Kosmos Nov 2 '11 at 9:24
4  
I don't think that the collaboration in database schema design is a sensible way to develop schema. It has side affects if someone is trying to modify the schema without considering the existing data. This is important even if projects are totally new. I would rather suggest tool like Liquibase as your candidate. –  Mike Lue Nov 5 '11 at 2:19
    
I'm inclined to agree with @Mike - can you elaborate on why you are looking for a tool that does this? –  Jack Douglas Nov 28 '11 at 10:03
add comment

4 Answers

You should check http://schemabank.com/ it seems to do all you want

Other alternative are solution blueprint or creately they are general propose colaborative UML design tools, but probably will also be useful for your needs

share|improve this answer
1  
+1 interesting. –  Jack Douglas Nov 28 '11 at 10:02
1  
Looks like schemabank.com is gone –  Neil McGuigan Jan 7 at 18:43
add comment

You could use subversion(SVN) as a way to work cooperatively on the structure of the database. It is also very useful when trying to figure out who changed what and when. It also gives you the ability to rollback changes to your code if a modification didn't work or caused problems.

I have often used SVN as a way to manage the code for databases, stored procedures and permissions for both MySQL and SQL Servers. It also provides a way to lock a file, so that no one else can edit it while you have it open.

Subversion Server: http://subversion.tigris.org/

You can then install Tortoise which can integrate with Windows to give you point and click access to your code.

Tortoise SVN Client: http://tortoisesvn.tigris.org/

You do need to have an Apache 2.2 server installed,

Here is a tutorial I found on the web which looks fairly straightforward.
http://svn-ref.assembla.com/subversion-server-guide-windows.html

Other solutions exist like sourcesafe and CVS, just depends on what you feel comfortable with.

share|improve this answer
add comment

You can use Vertabelo. Vertabelo is an online database designer working under Chrome developed by company I work for.

Vertabelo focuses on online collaboration in the visual database schema creation area. The most important feature of this tool is that it allow to share database models across the team and collaborate on them via web browser. It also allow to have public model link with possibility of embeding diagrams in your webpage/blog/wiki.

Others Vertabelo features include:

  • Support for PosgreSql, MySQL, Oracle, MS SQL Server, DB2, SQLite, HSQLDB
  • Dynamic/Visual search
  • Live database model validation
  • Model versioning
  • Forward engineering
  • Reverse engineering

Vertabelo is free to use for smaller projects (up to 3 models and 20 tables within each model) and have commercial versions for larger database projects.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.