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

closed as off-topic by Paul White, Max Vernon, RolandoMySQLDBA, Mark Storey-Smith, Kin May 1 at 14:25

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Max Vernon, RolandoMySQLDBA, Mark Storey-Smith, Kin
If this question can be reworded to fit the rules in the help center, please edit the 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

4 Answers 4

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

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

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

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