Migration from Native database(4.o) to SQL DB

Sapot
Sapot Member Posts: 50
edited 2009-10-26 in Navision Attain
Hi all,

We currently have Native data base for Nav4.0 the size of the database is 9GB.
We are migrating it into SQL. The backup taken from Native takes about 70hours to restore in SQL.

Can somebody please help with the following querries:
1) Process of Migration from Native to SQL.
2) Does it take 70 looooong hours to restore in SQL.

Comments

  • matttrax
    matttrax Member Posts: 2,309
    Grab the upgrade toolkit documentation from partnersource. There is an entire section devoted to upgrading from native to SQL.
    Matt Traxinger - ArcherPoint
  • kine
    kine Member Posts: 12,562
    9GB..... 70hours to restore in SQL

    I think that there is something wrong with your HW...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • DenSter
    DenSter Member Posts: 8,307
    Sapot wrote:
    <snip> 9GB <snip> takes about 70hours to restore in SQL.
    I had a 75GB database take about 6 hours to restore on my laptop. Try again on appropriate hardware.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • kine
    kine Member Posts: 12,562
    Or the DB is heavily over-indexed...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kriki
    kriki Member, Moderator Posts: 9,121
    Or you are doing the restore over the network (like fbk on computer A, the client that does the restore on computer B and the SQL server on computer C).
    You should have all and do all on computer C.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • DenSter
    DenSter Member Posts: 8,307
    We can speculate from here to Tokyo about what caused it to take so long :mrgreen:
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • David_Singleton
    David_Singleton Member Posts: 5,479
    DenSter wrote:
    We can speculate from here to Tokyo about what caused it to take so long :mrgreen:

    And since the original poster has gone AWOL, who knows what happened or is going to happen.
    David Singleton
  • Sapot
    Sapot Member Posts: 50
    Hi Sorry as i was sick & could not respond.
    The Version is Nav4.0 SP3 & SQL Server is 2005. I have taken the backup from Native database(It has 34companies, 9 Gb Size) created SQL DB & when i try to restore it get lot of issues. I created a TEST plan & could complete the first TEST & restoration(Took 70 Hours). When i am doing the same again in the TEST environment i have the beloe Errors:

    1) Taking about 70 Hours.
    2) I have issue with Windows Login sync(In the First Test).

    Please help me with following:
    1) Correct procedure of Native to SQL conversion.
    2) I was told that Microsoftt doesnot support migration from Native 4.0 to SQL.Is this true.
    3) Tests i need to perform after migartion to make sure i dont have any issue.

    Thank you all :(

Categories