Upgrade to NAV 2013 - Data Migration Issue

postsaurav

Hi all,

During Data Migration to NAV 2013 i have followed below steps -

1) Import fob from the DVD for Data Migration.
2) Run Step 1 in NAV 2009 R2
a) --> Data Transfer. [NO ISSUE]
b) --> Delete Objects. [NO ISSUE]
3) When i try to open the database in NAV 2013 (to start the Steps 2), while opening database below error occurs.

"The following SQL Server error or errors occurred:

5075,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]The object 'DatabaseSelect' is dependent on database collation. 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.
5072,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]ALTER DATABASE failed. The default collation of database 'DATABASENAME' cannot be set to Latin1_General_100_CS_AS."




SQL Server Version - Microsoft SQL Server 2008 Standard Edition (64-bit)
Please suggest how i can resolve this.

Thanks in Advance.

jglathe

Hi,

I tried to change the collation of a database (post-5.01, with views for SIFT tables) once, ond got about the same message in T-SQL. The fact is that you can't change the collation of the database - at least I didn't find a way to do so. Except: Do a .fbk backup, create a new database (with the right collation), re-import the .fbk backup. This way takes quite some time but it works.
The other question is: Does NAV2013 require this collation? I didn't notice because it's the collation I'm using anyway.

with best regards

Jens

postsaurav

Hi Jens,

Thanks for your inputs, it resolves the issue.

Just to put it step by step, how to resolve the collation problem-

1. Take navision backup of Database that you want to upgrade.
2. Create a new database with the collation that NAV is trying to set during Upgrade.
3. Restore the database.
4. Follow the upgrade steps provided by Microsoft.