Data migration very slow

zutzuzutzu Member Posts: 86
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

  • DenSterDenSter Member Posts: 8,305
    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.
  • zutzuzutzu 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.
  • DenSterDenSter Member Posts: 8,305
    Then locate someone who DOES have permission and have them do a SQL Server backup. A NAV backup will only create more transaction log.
  • zutzuzutzu Member Posts: 86
    Ok.
    Thanks.
Sign In or Register to comment.