Has anyone else done this successfully yet?

I had hoped that the upgraded intallation toolkit would make this process less painful, not more.

OK so here is an account of my experiences:

Having backed up the db (thankfully), I set it running. Initially it would not let me do the upgrade on my trusted login (although the option is there, I have database owner permissions and I have successfully used this login many times in the past - I gather this is a change from the previous installer). So I obtained the SA login and the installation now begins.

There are two progress bars visible, neither of which indicate any progress, although the title of the lower bar does change as items are written to different tables in the db. I left it running for at least 20 minutes and then returned to an unhandled error notification. The gist of which was as follows:

exception class   : EDBUpgraderError
exception message : Error occurred running script 00000010.sql. The error is described as: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

I clicked on Continue application and now I see a single progress bar, showing that the process is somewhere just past midway (with 14 grey blocks showing in the bar). After ten minutes more there was no change (still 14 blocks). So I stopped the installer. Recorder now reports that 0000000Z is the latest upgrade installed.

I restored from the backup and tried again, with exactly the same result, same error caused at about the same time, same progress bar still showing 14 blocks.

Given that there has been an error in the process, is there any point in me waiting any longer?

I have now quit the installer a second time and since the error was caused in 00000010.sql I assume that Z has been updated correctly.

I then ran the 10 script manually using management studio. This time I get essentially the same error message:

Msg 296, Level 16, State 3, Line 1
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
The statement has been terminated.

(0 row(s) affected)

This message is repeated 20 times, once for each of the twenty UPDATE statements at the top of the script? All the subsequent delete statements seem to have been executed successfully.

This makes sense since these twenty statements have a datetime value in them, which is clearly not being converted correctly on our system. The fact that Charlie's upgrade went through without errors suggests to me that this problem might (as in the past) be caused because we are using SQLServer 2000, which has slightly different syntax.

I have now restored back to dictionary Y and am awaiting further instruction.

Thank you for pointing out the problem. I have changed the download file and this will be updated in the next few days.  I have also altered the sofware which generates  the scripts so that this will not happen in future.  We will also check the upgrades on an SQL Server 2000 system in the future.

The deletes are Taxon_List_Items which have been deleted. It is no longer policy to do this and the deletions are there to prevent errors with some systems which didn't run the change scripts correctly in the past.

Thanks Mike

I don't know what is causing this. Can you make sure that 0000000Z.zip and 00000010.sql  are in the scripts folder. Then  copy 10 somewhere safe  and see if 0000000Z,zip will run on its own.

Attached is an upgrade file which does nothing, but should run and change the dictionary upgrade number  in the settings table. Remove Z and 10 to somewhere safe and put the attached  Z in the scripts folder instead. IIt is just designed to establish whether it is the contents of the upgrade or the upgrade application which is giving the problem. It is probably best just to stick with 4  for the moment.