database scripts

[derek]

Hi,

Could the database creation scripts be made available via the download page, please.  This should include the InnoDB and ISAM scripts for mysql.

Ideally, they would ship as part of the release so that there are not later versioning issues involved.

Q: If we create InnoDB tables, will support for transactions automatically be enabled in EA?

Regards
Derek

[gsparks]

Derek,

The scripts are at:

http://www.sparxsystems.com.au/ea_corp_ed.htm

I will get a link to that page set up from the download page as well.

We are not currently planning to include the scripts as part of the standard install. There are already 5 different scripts, and with support for other DBMS systems planned this will expand further. We feel it is better to make the appopriate scripts available on line so people can download just the ones they want.

Cheers,
Geoff Sparks

[derek]

Geoff,

Thanks for the links.  I now have 2 questions:
1. If we create InnoDB tables, will support for transactions automatically be enabled in EA?
2. Is the link to the InnoDB script correct?  I ask because it is identical to the MyISAM script.

Regards
Derek

[gsparks]

Derek,

Yes - transactions should be enabled automatically if you use InnoDB tables.

My apologies for the InnoDB scripts - the tool which generates the scripts seemed to go awry for that release - they have now been corrected.

Cheers,
Geoff Sparks

[James]

I'm assembling a trial of the Corporate Edition (we already use Professional) and had some trouble creating the initial database.  When running the script I had errors relating to the "COLLATE Latin1_General_CI_AS" statement in the Create Table commands.  When I removed it the script ran OK (there were still some reported errors about "incorrect use of ON in line 8" but the app runs fine now.

Is there a specific version of MS Sql Svr that you need?  I'm using MSDE 7.00.623 which should be equivalent to the 'normal' Sql Svr 7.0

What do these COLLATE commands do anyway and is omitting them important? - the SQL manual doesn't refer to them as a valid command