Can we upgrade NAV2013 dimensions direct from SQL side?

daborg
daborg Member Posts: 54
edited 2014-07-07 in NAV Three Tier
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.

Comments

  • ara3n
    ara3n Member Posts: 9,258
    its not done totally via nav code. the upgrade toolkit uses ADO and runs the sql commands.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • daborg
    daborg Member Posts: 54
    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
    thegunzo Member Posts: 274
    What are you hoping to gain by doing you own SQL dimension upgrade ?
    ________________________________
    Gunnar Gestsson
    Microsoft Certified IT Professional
    Dynamics NAV MVP
    http://www.dynamics.is
    http://Objects4NAV.com

Categories