What is involved in upgrading from 2.60F SQL Option to Attain 3.10 SQL Option. Since we already went through SQL migration on 2.60F, is it necessary to go through it again? I just opened Attain SQL Server Option, pointed to a development 2.60F SQL database and it converted it in 2 minutes and I was in. In reading documentation from Navision, it all talks about this looooong process of upgrading a database, but it is all referring to C/SIDE. It SQL->SQL that easy, or am I missing something? Devin W. McMahon, MCDBA
It could be a “looooong process” if You want to upgrade the functionality in Your 2.60 to Attain. But if You only want to upgrade to the latest “Run Time” we are probably talking about two minutes. Although I recommend You to always make a backup with the previous version (and an SQL Backup), delete the database and create a new empty database with the new executables and restore the backup with the Attain Client. That’s allways the safest way. //Lars
We are using Attain 3.01b Client and database version 2.01b on SQL. It works but… the problem is that the help-system changes from *.hlp to *.chm. You will destroy the “online help functionality” because the new *.chm files describe the functions in the database version 3.x and not your current 2.x version. At the moment i try to convert the 2.x helpfiles to *.chm and implement them in the attain-client but i have no solution jet. Just because these huuuuges differences between 2.x database and 3.x database they are talking of a looooong prooocessss and the helpfiles are verrrrry difffferrrrent. To get your database-version just click on “?” and “info…” on your menubar. You will get your version like “Databaseversion (Clientversion)”, in my case “DE 2.01.B (DE 3.01b)” . bye Stefan Edited by - StefanZimmer on 2002 Aug 13 19:27:11
The SQL version was introduced in Financials 2.5 and the version number you’re seeing has nothing to do with the SQL database actually. The SQL database itself has a version number but this is a simple integer (it is stored in the [databaseversionno] field of the [$ndo$dbproperty] table.
Dont get me wrong, when i’m talking of “database-version” its the “Navision-database-objects” (tables, forms, reports, etc.) stored on sql not the SQL-Version. bye Stefan