Migrate from Native database to sql 2012

sandrav · 2013-03-26

Hello

I am about to migrate a native database containing several companies to sql 2012.
I have ran a test with migrate toolkit.
I noticed that it identifies all dates that have a problem. The suggested date given is the same for all lines.
If I want the correct date, do I have to correct it manually one by one or is there a possibility to have them corrected automatically?

Also can I run the codeunit for all companies at one time, I mean it checks the whole database at one go?

Thanks for assistance.

kriki · 2013-03-27

You have to check the dates manually, but you can speed it up. Generally when you have a wrong date e.g. 31/1/0004 it probably should have been 31/1/2004. You can filter ALL dates 31/1/0004 and change the first to 31/1/2004. Then you can use F8 to copy the value very fast to the other records. Most of the time, all the records with the same wrong date are of the same posting.

If I am not mistaken, the migrate.fob codeunit checks all companies in 1 go.

sandrav · 2013-03-29

Thanks a lot for this tip.

Migrate from Native database to sql 2012

Comments

Categories