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?
-
1related stackoverflow.com/questions/2518277/…– UnreasonOct 31, 2011 at 12:30
-
that question has 1 year old, I am interested in more recent solutions if there are and you know some of.– radu cNov 2, 2011 at 9:24
-
5I 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 LueNov 5, 2011 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 DouglasNov 28, 2011 at 10:03
-
I'm considering adding a Wiki on project GitHub to collaborate and discuss the data-model.– AakashMay 31, 2021 at 11:05
Add a comment
|
4 Answers
You can use Vertabelo. Vertabelo is an online database designer working under Chrome and Safari 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 academic projects and have commercial versions for larger database projects.
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
-
6
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.
answered Nov 28, 2011 at 5:50
WWW SQL Designer
answered Jun 25, 2012 at 6:25
