SQL Server 2008?

[JoeCool]

In the user guide for EA on page 1067 it says that SQL Server 2008 is supported. However, when I check a table's properties and select the database, only versions 2000 and 2005 are listed (plus a cryptic "SQLServer7," which I have no idea what that is). What's going on here...? Is 2008 supported or not? I need to use the new FILESTREAM datatype, so that's why I ask.

Thanks,
-Robert

[Graham_Moir]

Just for completeness SQLServer 7 was the version before SQLServer 2000 (and before Microsoft changed the versioning)

[«Midnight»]

First make sure you are using EA 7.5. SQL Server 2008 support did not appear until then.

If you have upgraded, start a new project. This will ensure you are not working with outdated reference data. EA defines database datatypes in reference data, and projects created with earlier versions did not get the new definitions. Even if you update EA, those projects will still reflect the old data.

If that does not work, see if the EABase or EAExample projects shipped with version 7.5 list SQL Server as one of the supported databases. If either one does, export the relevant reference data and import it into one of your models.

If none of the above got you any results, contact Sparx support and have them send you an updated reference data extract. For some reason some EA 7.5 kits did not have the SQL Server 2008 datatypes - I had one of those - and an update is needed. Sparx sent me the necessary file right away. [But remember that Sparx is in the Land of AUS, so their weekend starts very soon!]

HTH, David

[JoeCool]

David, thanks for the very helpful in-depth response. I'm actually using the trial version at the moment (I'll have a license to the full one soon). The version number I'm using is 7.5.845 (Build: 845)

I started with a fresh project, so it's not an old data problem. I'm not sure if the trial comes with the sample projects, but I'll check.

Either way, thanks for the help!

-Robert

[«Midnight»]

Robert,

When you are not running EA make copies of EABase.eap and EAEXample.eap - they should be in the installation directory. Move those copies to a working directory and open each in EA. Check whether you can find SQL Server 2008 in the Database Datatypes dialog.

If not, send a message to Sparx support immediately. It will be Friday AM there soon so you want to give them time to send you the data before the weekend. It would not hurt to include the URL of this forum thread in your email.

HTH, David

[JoeCool]

David, I used EABase and was able to integrate the SQL Server 2008 support into my existing model. Thanks so much for the help, much appreciated!

-Robert