Navision Native database import to SQL 2005

BoboXie

Hi everyone;
I need import our Navision 4.0 sp2 dababase to SQL 2005.
First i did the backup for Native fdb database.
Second i created a new database in SQL2005 with Navision.
Third i restored the new database with the backup one.
But when i did the step, it will give me some error message with the exist date error 'which table','which record','which vaule'. I Checked it in Navision system, it is error date format.
So i need a tool to find all incorrect date format. And i search it within website.
And somebody said it can use SQL-migration tool.
Who can sent me the tool or a site can download it? Or tell me other tools which can find the incorrect date list?

Thanks to everyone.
My e-mail address: bobo.xie@gmail.com

garak

Follow this link.

navuser1

Hi BoboXie

try this.

OBJECT Codeunit 50001 Find wrong date
{
OBJECT-PROPERTIES
{
Date=12/03/08;
Time=11:54:35 AM;
Modified=Yes;
Version List=Limtex;
}
PROPERTIES
{
OnRun=BEGIN
Window.OPEN(Text001);
Field.RESET;
Field.SETRANGE(Field.Type,Field.Type::Date);
Field.SETRANGE(Class,Field.Class::Normal);

IF Field.FIND('-') THEN BEGIN
REPEAT
RecRef.OPEN(Field.TableNo);
RecRef.RESET;
RecRef.SETVIEW := STRSUBSTNO(TxtFilter,Field."No.");
IF RecRef.FIND('-') THEN
BEGIN
Window.UPDATE(1,Field.TableNo);
Window.UPDATE(2,Field.TableName);
Window.UPDATE(3,Field."No.");
Window.UPDATE(4,Field.FieldName);
Window.UPDATE(5,RecRef.FIELD(Field."No."));
SLEEP(1000);
END;
RecRef.CLOSE;
UNTIL Field.NEXT =0;
END;
Window.CLOSE;
END;

}
CODE
{
VAR
gRecSalesShipmentLine@1000000000 : Record 111;
Object@1000000001 : Record 2000000001;
Field@1000000002 : Record 2000000041;
Window@1000000003 : Dialog;
Text001@1000000004 : TextConst 'ENU=Table ID #1##########\\Table Name#2##########\\Field ID #3##########\\Field Name#4##########\\Date #5##########';
RecRef@1000000005 : RecordRef;
TxtFilter@1000000006 : TextConst 'ENU="WHERE(%1=FILTER(01/01/0000..01/01/1800))"';

BEGIN
END.
}
}

BoboXie

Thanks both.

Dear Garak:

Which place can i download the upgrade toolkit?

Which place can i download the migrate.fob?

Waiting for your reply online

Thanks again

garak

If you are a partner, you can download it from partnersource.
If you are an enduser, contact your navision partner.

BoboXie

Oh, i am enduser.

Could you give me one? if you can not send me, i also thanks for your help.