1 Reply by AndyFoy

  • AndyFoy
  • Consultant
  • Offline
  • Registered: 09-08-2006
  • Posts: 219

Re: Apply Dictionary Updates Manually

Hi,

Is it possible to apply dictionary updates without using the Dictionary Upgrade application?

Because we are hosted within a county council we have to jump through all sorts of change control hoops and wait weeks for an IT resource to be available to apply the updates (and do the whole thing first in a test environment before they will apply them live).

As I presume the updates are just changes to the database content I was wondering if I could apply the .sql updates through the MS Access interface and/or by importing the .zip files through the import user interface?

Does anyone else do it this way or does anyone know if this is possible?

Thanks,
Andy

Andy Foy
Systems Manager
Greenspace Information for Greater London (GiGL) CIC
www.gigl.org.uk

2 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Apply Dictionary Updates Manually

Hi Andy
This is certainly possible, though I would not run the SQL files through the MS Access interface if possible as it has a tendency to mess around with the SQL file before it sends it. You might get away with it if you set the Passthrough option on the query but it warrants testing before trying on a live database. I appreciate you may not have this option, but the ideal would be to install something like SQL Server Management Studio Express which is a free download from Microsoft that gives you a SQL Server specific interface to the database. Also, make sure you run the scripts and zip file imports in the correct sequence. Finally you would need to change the information in the SETTING table for the row where NAME='DB Seq' so that the data points to the latest file that you imported.

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by AndyFoy (edited by AndyFoy 05-11-2010 17:15:27)

  • AndyFoy
  • Consultant
  • Offline
  • Registered: 09-08-2006
  • Posts: 219

Re: Apply Dictionary Updates Manually

Hi,

Thanks John.  I might hold off on the SQL scripts and only apply the .zip imports myself.  By the way ...do you mean DB Seq or Dict Seq?

Also, can anyone tell me ... should dictionary updates Q, R, S & T only be applied once the application is upgraded to 6.15 or can they be applied when using 6.14.4?

Thanks
Andy

Andy Foy
Systems Manager
Greenspace Information for Greater London (GiGL) CIC
www.gigl.org.uk