migration navitive database to MS SQL 2008

Business Central/NAV Technical Forum
1

Hi All,

First of all, sorry for my English :).

I have native database NAV 5.01 with LS Retail and I would like migrate this database to SQL 2008. Could you send me procedure how can I should do this?

On my trial server I migrate:

  1. Backup native database

  2. Create sql database

  3. Restore native database to sql database

Best regards

Daro

2

Hi Daro,

welcome to the “Dynamics User Group” [<:o)]

Well, unfortunately migrating from “native” to SQL Server is not that easy … Have in mind there is an “Upgrade Toolkit” available including a document which describes the requirements and “Do s & Don’t s” in detail …

Also please search the forum and you’ll gent plenty of advices and recommendations!

Cheers,
Jörg

3

Hi

Thank you for answer. Could you recommend me any books about implementation NAV and optimization database SQL of NAV?

Best regards

Darek

4

Hi Darek,

Have a look in the recommended book section link off the home page

I can highly recommend Joerg own book “The NAV/SQL Performance Field Guide” for optimization

Hi Joerg,

You should consider adding this to the recommended book section link [;)]

5

Thanks a lot [;)]

6

… no Thank you, your book has help me numerious times [Y] [:D]

7

Hi Jorg

Could you tell me which solution migration is correct:

I. solution

  1. import object migration to native database

  2. run codeunit 104010

  3. import FIELDCHK.TXT

  4. compile codeunit 104015

  5. run codeunit 104015

  6. make backup nativ database

  7. create new sql database

  8. restore native database to sql database.

or

II. solution

  1. make backup nativ database

  2. create new sql database

  3. restore native database to sql database.

  4. import object migration to native database

  5. run codeunit 104010

  6. import FIELDCHK.TXT

  7. compile codeunit 104015

  8. run codeunit 104015

Best regards

Darek