how to migrate native databse of navision to sql server 2005

mggoswami

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

Luc_VanDyck

Have a look at this topic: Conversion of Native datbase to SQL Server

Waldo

Shall I "stress" it again ... ?

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

Luc_VanDyck

Sure, but first the data needs to be in a SQL database. And that was the question #-o

ssingla

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.

Luc_VanDyck

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.

kriki

[Topic moved from Navision forum to SQL General forum]