I just tried this out Geert...
There were several issues with finding the database itself. These were all results of Vista, local net configuration, or both.
I used the script that is still labeled for SQL Server 2000 and 2005.
[edit]Bug reported.[/edit]
This script continues to require you to add a USE statement, and still writes to the default database if you do not. [I'd recommend a dummy USE statement so the script would throw an error if it were not edited, instead of corrupting a valuable resource. But of course that's only my opinion...]
[edit]Bug (IMHO at least) reported.[/edit]
In any case the script seems to work just fine with 2008, despite not being documented as such (on the Sparx Resources page).
Trying to connect via the new Native SQL Client 10.0 was a complete loss. The connection sets up and tests just fine as far as the Windows dialogs are concerned. When you try the transfer EA instantly (i.e. with no delay) reports that it cannot open the target. Note that this error message is issued even if the create log option is checked but no log file is entered; EA signals the error even before 'discovering' that you have not entered all the mandatory information.
[edit]Bus reported.[/edit]
I recreated the connection using the OLE client for SQL Server. This time the connection worked fine - except that I had to correct my (now invalid) log settings of course. At this point I got an error message that EA could not open the file because it was locked by another user. This was not the case since I was using a local file and EA had no open project.
The problem was due to my attempt to transfer the EABase project. Even after making a copy of EABase the and trying to transfer the copy I got the error. What was happening was that EA was not able to open the project since due to Vista protecting the folder. [That's good for many reasons.] The 'helpful' error message gives incorrect information in this case. Moving the source - the copy of EABase - to a user directory elsewhere solved the access problem.
The transfer process then completed as expected.
Finally, just to be sure, I opened the new repository in EA, created a package, added a diagram, and dropped a class onto the diagram. I then saved and close EA. Opening the database in SQL Server I was able to verify that the records were created. [Of course they were since EA gave no complain, but after the saga above I was feeling a bit sceptical.]
HTH, David
