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?
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:
You should check http://schemabank.com/ it seems to do all you want
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:
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.
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.
Other solutions exist like sourcesafe and CVS, just depends on what you feel comfortable with.