How to do Data Transfer?

chandrurec

Hi all,

I want to move the datas from one Database to another database(both the databases belong to the same version 5.0).
Is there any tool or defualt functionality by which I can achive the data transfer.

Thanks in advance.

Regards,
Chandru.

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

matttrax

Why not just do a backup and restore?

kapamarou

Please let us know why you need this. Is it for a one-time task? Is it for a process that will be repeated? Is it for all data? Are the Object the same?

Alex_Chow

You can check out Data Migration under the Application Setup --> Company setup.

It copies some data, but not all the data you will need.

chandrurec

Hi all,

The Information provided by all of you is very useful regarding data migration. Thanks to all of you.

Another doubt which I have in Data migration is when we go to the migration screen by follwing the steps below

Click Migration menu in Data Migration -> select Migration Fields option

By default only some fields are selected.If i want to select all the fields , I want to do it manually and its very time consuming.Is there any way by which i can select all the fields by a single mouse click.If so , Kindly tell me the way to select all the fields in Migration Fields window by a single click.

Thanks in advance.

Regards,
Chandru.

veerendra

I think it is not available but why can't you do this simple modification

Migration Table - OnInsert Trigger
Fields.SETRANGE(TableNo,TableID);
IF Fields.FIND('-') THEN
REPEAT
MigrationField.TableID := TableID;
MigrationField.FieldID := Fields."No.";
// MigrationField.Include := IsKeyField(MigrationField.TableID,MigrationField.FieldID);//commented code
MigrationField.Include := TRUE;//New Code
MigrationField.Validate := TRUE;
MigrationField.INSERT;
UNTIL Fields.NEXT = 0;

chandrurec

Hi Veerendra,

Thanks man It works fine now.

Regards,
Chandru.