Issue with schema export

ngoodwin · Post by **ngoodwin** » Wed 29 Jul 2009 13:17

I exported a schema today and found a very strange bug.
What should have been generated:
CONSTRAINT FOREIGN KEY (SomeId)
REFERENCES fkTable(Id) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT FOREIGN KEY (SomeId2)
REFERENCES fk2Table(Id) ON DELETE NO ACTION ON UPDATE NO ACTION,
What was generated:
CONSTRAINT FOREIGN KEY (SomeId)
REFERENCES fkTable(Id) ON DELETE NO ON UPDATE NO ,
CONSTRAINT FOREIGN KEY (SomeId2)
REFERENCES fk2Table(Id) ON DELETE NO ON UPDATE NO ,
Was wondering if you guys knew about this, if it could be fixed, or if i'm just doing something wierd. Thanks!

Alexz · Post by **Alexz** » Wed 29 Jul 2009 14:22

Actually our application doesn't write DELETE or UPDATE rules for foreign keys if they are set as NO ACTION, because this is the default behaviour.

Can you provide us with additional information:
1. What version of MySQL server do you use?
2. What version of dbFroge Studio for MySQL do you use?
3. Could you send us the DDL text of these tables?
4. Which wizard do you use to generate DDL text (Schema Export wizard or Generate DDL wizard) ?

ngoodwin · Post by **ngoodwin** » Wed 29 Jul 2009 14:29

Latest DevART dbForgeFusion i JUST installed it.
Here is the top with info about it
-- Script was generated by Devart dbForge Fusion for MySQL, Visual Studio 2008 Add-In, Version 3.50.327.0
-- Script date 7/29/2009 8:48:14 AM
-- Server version: 5.0.67-community-nt-log
-- Client version: 4.1
and i tried with both schema export and generate DDL.
I think i may have a problem though, for example i don't have any devArt projects in the file->new menu...

ngoodwin · Post by **ngoodwin** » Thu 30 Jul 2009 15:50

Okay i think i have a bigger issue, i can't seem to create a project. Following the working with projects how to i can't even seem to create a project. The templates just don't exist. Any ideas?

Alexz · Post by **Alexz** » Fri 31 Jul 2009 08:12

Unfortunetly, we cannot reproduce the problem with FOREIGN KEY DDL text generation. We've tested on many MySQL servers..

I think i may have a problem though, for example i don't have any devArt projects in the file->new menu...

What edition of dbForge Fusion for MySQL are you using?
Projects are available only in professional edition. For more information, please read the article at http://www.devart.com/dbforge/mysql/stu ... tions.html