I came across a SQL issue when I was converting to NAV2013 from a NAV2009R2 database. Upgrade step 1 was completed and when I tried to convert to NAV2013 (using a NAV2013 environment) it gives me a SQL error that 'the object 'xxx' is dependent on database collation (error 5075, 42000) The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation'. The object, where the error is related to, was found on the SQL server on the specific database under 'Functions'. If I script out the function (export as SQL Script and delete the function), the error is gone. But there are quite a few SQL functions. So I'm concerned that I need to do this for every single function (or view). Is there any other option or do I overlook something?
0