GP Database Upgrade

[scuttlebuttin]

I have a test environment with GP 9.0 and want to move a database/company
from GP 8.0 to the test server; then i want to upgrade just that one
database/company to 9.0.

I successfully imported the database into SQL 2000 from GP 8.0 server to the
test GP 9.0 server but when I run the utilities, I don't have the option to
upgrade the database/company to 9.0. Is there something missing in the
Dynamics table that I need to add manually so that the utility tool
recognizes that a database as been added that can be upgraded? Any other
thoughts?

Thank you.

 

[Sniper187]

Run the following script againt the DYNAMCIS database to set the Dynamics the version of the database is 8.


use DYNAMICS
declare
@companyDBName as char(5),
@companyName as char(65),
@version as numeric(3,2),
@verMajor as int,
@verMinor as int,
@verOldMajor as int,
@verOldMinor as int,
@companyID as smallint
set nocount on
set @companyDBName = 'XXXXXX' --Insert Database ID here
set @version = 8.0

if (@version = 8.0 or @version = 8)
begin
set @verMajor = 8
set @verMinor = 0
set @verOldMajor = 7
set @verOldMinor = 50
end

set @companyID = (select CMPANYID from SY01500 where INTERID = @companyDBName)

delete DB_Upgrade where PRODID <>0 and db_name = @companyDBName

delete DU000020 where PRODID <>0 and companyID = @companyID

update DB_Upgrade set db_verMajor = @verMajor, db_verMinor = @verMinor,
db_verOldMajor = @verOldMajor, db_verOldMinor = @verOldMinor, db_verBuild=0, db_verOldBuild=0, db_status = 0
where PRODID = 0 and db_name = @companyDBName

set @companyName = (select CMPNYNAM from SY01500 where INTERID = @companyDBName)

update DU000020 set versionMajor = @verMajor, versionMinor = @verMinor, versionBuild = 0 where companyID = @companyID and PRODID = 0

delete DU000030 where companyID = @companyID

delete duLCK

set nocount off



You should now be abel to lanuch Dynamics Utilites and upgrade the database.