Options

how to migrate native databse of navision to sql server 2005

mggoswamimggoswami Member Posts: 14
edited 2007-05-17 in SQL General
i m unable to migrate native database of navision to sql server 2005
it is showing error g/l entry table how to correct the date of g/l entry table
and can we do it through developememt toolkit
please suggest me best solution of this

Comments

  • Options
    Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Have a look at this topic: Conversion of Native datbase to SQL Server
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Options
    WaldoWaldo Member Posts: 3,412
    Shall I "stress" it again ... ?

    Incorporate some SQL tuning ! This will most probably be necessary!

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Sure, but first the data needs to be in a SQL database. And that was the question #-o
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Options
    ssinglassingla Member Posts: 2,973
    Do we need developer licence to modify dates in gl entry table . If yes, then is there any workaround so that client can modify it with its licence.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Options
    Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    If permissions to the G/L Entry table has been set in the object that performs the modification of the dates, then it can be run by the client. But the objectnumbers then needs to be in the range that is allowed by the client as well.

    So I guess this task is done by someone with a developers license.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Options
    krikikriki Member, Moderator Posts: 9,090
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.