SQL Server 2000 to 2005

Comments

• Waldo Member Posts: 3,412

  2007-05-04

  About SQL2005?
  Or about the move to SQL2005?
  There is much to find about this on the microsoft site
  
  There are several options to do so:
  - NAV backup / restore
  - SQL backup / restore
  - Detach / attach
  
  I tried them all, and all works for me... . My favourite is the NAV backup / restore, because in that way, all is rebuilt nicely like it should.

  
  Eric Wauters
  MVP - Microsoft Dynamics NAV
  My blog
  

  0
• diptish.naskar Member Posts: 360

  2007-05-04

  As such there are no whitepapers available on the net. For upgrading to SQL server 2005 you can however do the following
  
  1. Take a backup of NAV db
  2. Uninstall the SQL server 2000 and the DB server of NAV(if they are on the same machine)
  3. Install the SQL Server 2005
  4. Ensure the services are running properly
  5. Intall the NAV db server
  6. Restore the backup
  6. Synchronize with SQL server 2005
  
  I beleive this will suffice the migration from SQL server 2000 to 2005.
  
  you can also see some article in
  
  https://mbs.microsoft.com/customersourc ... page=false

  Diptish Naskar

  ---

  For any queries you can also visit my blog site: http://msnavarena.blogspot.com/

  0
• Sorcerer Member Posts: 107

  2007-05-04

  diptish.naskar wrote:

  5. Intall the NAV db server

  
  what do you mean by NAV db server? native server?
  why do you want to install a NAV db server?

  0