3

I have a database model diagram created in MS Visio which I would like to export to DDL file to create a MySQL database. I've already installed the MySQL ODBC driver, which I can successfully use to generate DDL file, but I have some problems anyway.

Visio puts quotation marks around the table names which are also reserved words (like user). This is not OK, since MySQL uses backticks (`) and not quotation marks (") for this purpose.

MySQL ODBC driver also changes the BLOB data type to LONGVARBINARY, so it cannot be used directly with MySQL when creating the database.

Does anyone have any suggestion how to deal with these two problems?

aks
  • 292
  • 1
  • 5
  • 12

1 Answers1

3

Other than editing it? No.

You might consider using MySQL Workbench. It is very similar to visio if you create everything in design mode. Additionally, with the paid version you can generate a pdf document as well for distribution (or plop that PDF into the flow chart diagrams, etc in visio) or you could possibly create a plugin that would generate a valid visio file on output since workbench is fully extensible via plugins.

Kevin Peno
  • 9,107
  • 1
  • 33
  • 56
  • That's what I did in the end. – aks Feb 12 '10 at 12:09
  • 4
    I find that software very buggy. – slotishtype Aug 02 '11 at 09:29
  • @slotishtype, In the early days I would have said the same. However, I will say that they seem very responsive to bug reports. I filed a few back in the day and they were resolved pretty quickly. I'd advise you to report your errors! http://wb.mysql.com/?page_id=53 – Kevin Peno Aug 02 '11 at 16:21
  • Fair enough. I used visio to reverse-engineer a database yesterday and it worked a treat. I was labouring with the workbench before hand. Good it works better now. – slotishtype Aug 03 '11 at 08:23
  • @slotishtype, yeah I like Visio 2010 tbh because I can focus on modeling for anything, not just mysql. I use MySQL Workbench when I'm in a mysql shop that can't afford to give me the tools I prefer :P – Kevin Peno Aug 03 '11 at 17:58