+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, SIMS Version - SQL extract in Technical; hello Does anyone here know where the SIMS version is held in the SQL tables. We want to run a ...
  1. #1

    Join Date
    Jan 2008
    Posts
    5
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS Version - SQL extract

    hello
    Does anyone here know where the SIMS version is held in the SQL tables.

    We want to run a SQL script across a lot of our Schools to check the SIMS version. Need to make sure they are all upgraded to the same version (don't trust what Schools Manager is telling me!)

    thanks

    Suzanne

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,641
    Thank Post
    685
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    hiya,

    i'm not sure where you are coming from here.

    why does it have to be a sql script? surely that means that you would have to have the password for each school, and then you'd have to have a master script to connect to each separately. or are the passwords all the same. i'm not sure, not done a lot of SQL for a very long time.

    if you have got access to the servers, there are a number of files that have indicators to the version running:

    ~simsload.ini has the app version
    ~simsload.exe has an embedded app version no. that is used by the program itself at client workstation level to determine if in fact an update is required.

    if it's actually the version that you see from the help menu that you are after e.g. 7.99

    on the server if you go to C:\Program Files\SIMS\SIMS .net the drive letter may be different, in there the file pulsar.exe has the file version number as part of it's hidden (right click - properties) data. mine at the moment gives 7.99.5.0 which is a bit finer than needed.

    that information is available with a simple WMI script, that i could probably look up if it's any use.

    i hope i'm following you on the right lines.

  3. #3

    Join Date
    Jan 2008
    Posts
    5
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    thanks

    Thanks guys, all info much appreciated.

    Will go have a look at sims.db_version_info.

    cheers

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS Web version
    By mark in forum MIS Systems
    Replies: 49
    Last Post: 23rd March 2013, 12:17 PM
  2. SIMS.net December Upgrade - What version?
    By andyl in forum MIS Systems
    Replies: 9
    Last Post: 9th January 2008, 10:41 AM
  3. Replies: 2
    Last Post: 10th December 2007, 10:30 AM
  4. SIMS and SQL, which version
    By andrewsmart in forum MIS Systems
    Replies: 4
    Last Post: 14th June 2007, 08:13 PM
  5. New July Version of SIMS.NET
    By Simcfc73 in forum MIS Systems
    Replies: 38
    Last Post: 21st August 2006, 10:50 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •