Restore SQL backup to newer version

Business Central/NAV Technical Forum
1

I have a version of Navision 3.10.A running on a developers version of SQL v8

I’d like to move the database to a newer 64 bit machine running SQL v9. Does anyone know if I can restore a SQL 8 backup to the newer SQL v9? If it is possible, are there any issues connecting Navision 3.10 to the new SQL version that I will encounter?

Here is queried database version info:

FROM: 8.00.2039 SP4 Developer Edition

TO: 9.00.3068.00 SP2 Standard Edition (64-bit)

Thanks,
Doug

2

Navision 3.1 is not supported on that version of SQL Server. You would have to do an executable upgrade to a version of NAV that is supported.

3

As Daniel said, you need to upgrade (at least technically) to NAV 4.0 SP3 Update 6 or higher. For the SQL Server you should use at least SP 2 Update 4 Build 3200 or higher.

Things you have to/should adjust after restoring the old SQL 2000 backup into SQL 2005:

  • Run a DBCC UPDATEUSAGE
  • Switch “Page Verify” to “CHECKSUM”
  • Change “Compatibility Mode” to 9.0 (2005)

But: if you have to upgrade anyway, why not migrating to a real recent version; e.g. NAV 2009 on SQL 2008 or something? And have in mind, that there might be other issues coming with the upgrade, so test it thoroughly!

4

Thanks Jörg,

I did as suggested, all seems ok, the database is working fine.
We recently upgraded to 5.0 and I was trying to move the old 3.0 database to the new server so people can access history.
I also set the database to read only since this is going to be an archive.

Thanks again