Data migration very slow

zutzu
zutzu Member Posts: 86
edited 2008-03-17 in NAV/Navision Classic Client
I am importing data with migration data tool.
In the same day, i import some files.
The first files imported go fast.
But with the next files, it goes very very slowly.
Next day, it starts very good and with the next files, the same thing (very slow).
It seems like log file get full and when the programming backup is done (every day) log file gets empty and you can continue importing data without problem until log file gets full.
Any idea?

Thanks

Comments

  • DenSter
    DenSter Member Posts: 8,307
    You've kind of hinted at a solution: take another backup at midday. You can also truncate the log without taking a backup, read Books Online how to do this.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • zutzu
    zutzu Member Posts: 86
    To truncate the log, i think that i must have sql permission.
    And i am in a client where i haven´t those sql permissions.
    And, if i make a navision backup, the problem continues.
  • DenSter
    DenSter Member Posts: 8,307
    Then locate someone who DOES have permission and have them do a SQL Server backup. A NAV backup will only create more transaction log.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • zutzu
    zutzu Member Posts: 86
    Ok.
    Thanks.

Categories