Can we upgrade NAV2013 dimensions direct from SQL side?

daborg

While I appreciate all of the work that went into the upgrade toolkit to make the dimension upgrade as fast as possible, I'm looking for a bit more control over the upgrade process. I'd like to be able to execute the dimension portion of the upgrade directly from SQL Mgmt. Studio instead of via the NAV code.

Has anyone gone through the work yet of building a SQL script (or set of scripts) that mimics the dimension portion of the upgrade toolkit?

Thanks.

ara3n

its not done totally via nav code. the upgrade toolkit uses ADO and runs the sql commands.

daborg

Yes I understand that but what I want to do is take the somewhat hard to read NAV code that builds the queries, and transform them into a query that I can run individually directly within SQL Mgmt. Studio. I'm just wondering if someone has done that work already and can share. I know I can use profiler to watch the queries as well.

thegunzo

What are you hoping to gain by doing you own SQL dimension upgrade ?