SQL Server 2008 Support?

[yw]

Does EA support SQL Server 2008 as its backend database? I’m trying to use the "Data Transfer" functionality in EA to migrate my .eap file into SQL Server 2008, but the process is hanging after a certain amount of data is transferred. Some data does get transferred to the SQL Server 2008 database, but the process never completes.
 
I’m using EA version 7.5 Ultimate trial, Windows XP SP2, and SQL Server 2008 Standard Edition.

Thanks.

[destructodave]

I am also having the same issue.  I do the transfer and it fails with the following error:

The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
[Select * from t_document]
Field: bincontent

I am transfering from my local EAP file to my local SQL Server 2008 Developer Edition database.  There are no other users with access as it's a stand alone model at the moment.

Any help would be appreciated as I am moving our model from an EAP file to SQL Server 2008 with TFS as the soruce control.

thanks,

Dave.

[destructodave]

Just a side note to this, I've retried the transfer but this time doing an .EAP to .EAP transfer.  I copied the existing .EAP file, renamed it and then tried the transfer to teh newly renamed EAP file.

I get the same error.

So this appears to maybe be an issue with the Jet engine?

Any clues?

[destructodave]

Ok, so I played around for a while and finally decided to do a "Compact .EAP file..." which took the model from 45MB to 9MB.  No idea what this does yet, or if it's a good/bad thing to do, but I was looking for answers and running out oftime to get my model under source control within a DBMS.

Anyway, after I did the compacting the data transferred successfully from an EAP to EAP and an EAP to DBMS....excellent!!!

So I guess the answer to my question is to perform a Compact if you get a Jet error?  :-?

Sorry, this isn't an issue with SQL Server 2008 as I have successfully imported to it now.

[mrf]

Dave,

Regarding the compact functionality, it is there because of how Access treats deleted data. To quote a previous post:

You will also find that when you delete records in Access they aren't properly deleted. Instead they are moved to a "trash" table to facilitate undo later on. I've at one stage had an empty model take up 400Mb!

To clear out this trash table you can use EA's compact feature by selecting Tools | Manage .EAP File | Compact .EAP File from the main menu.