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

Sapot

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.

matttrax

Grab the upgrade toolkit documentation from partnersource. There is an entire section devoted to upgrading from native to SQL.

kine

9GB..... 70hours to restore in SQL

I think that there is something wrong with your HW...

DenSter

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.

kine

Or the DB is heavily over-indexed...

kriki

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.

DenSter

We can speculate from here to Tokyo about what caused it to take so long

David_Singleton

DenSter wrote:

We can speculate from here to Tokyo about what caused it to take so long

And since the original poster has gone AWOL, who knows what happened or is going to happen.

Sapot

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