Unable to upgrade a database with a . in it's name

Hi,

I've just tried updating a database from 9.2.9.10497 to 10.3.0.5640.

My database had a . in it's name (e.g. TestUpgrade.10) when I ran the upgrade script I got errors and a lot of (0 row(s) affected) messages than the normal patch messages:

Changing the databases name to remove the . and rerunning the script fixes the problem and the upgrade runs as normal:

Obviously not a common case, but had me scratching my head for a while!

Thanks,
Rhys

Parents Reply Children
  • What appears to have happened is what happens when an error occurs the first time you run the upgrade script, then you reran in the same current correction to the db.  When an error occurs, to prevent the upgrade script from going through all schema patches after one errors, we throw a noexec which prevents the rest of the schema patches from running, however, it continues at creating views and procedures due to the go commands in that portion of the upgrade script. 

    If you don't close and reopen you connection, you'll get the output you provided.  There are no issues running a database with a period in the name.

    I'd highly recommend you restore your database to before the upgrade and rerun the upgrade.sql to ensure no errors were missed when it first ran against your 9.2.9.10497 version database. 

  • Yep, sorry that appears to be the problem, pretty odd to track down but makes sense.

    Thanks,
    Rhys