How to tell which SQL database is which in FIS

Home Forums Data issues How to tell which SQL database is which in FIS

This topic contains 1 reply, has 2 voices, and was last updated by  Martin West 7 years ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts

  • Caspar Verney
    Participant

    For those who use SQL Management Studio, I share the following trick that I learnt from someone at the IA:

    Open the database called FundingInformationSystem and then open the table called DataSet. The column called DataSetVersion should tell you the version number (unfortunately mine had two version ones, of the same database, whereas FIS reported versions 1 and 2, which I have reported to the DS). The column called DatabaseName tells you exactly that.

    This is particularly useful if you are wanting to find out which database is which and your version of FIS has downloaded multiple versions of any of the databases, such as LARS..

    HTH
    Caspar

     
    #3530

    Martin West
    Participant

    You can also identify the latest version of a FIS database by running the following pass through query from Access:
    SELECT dbid, name FROM master.dbo.sysdatabases WHERE Left(name,3)=’FIS’ ORDER BY dbid;
    The one with the highest dbid will be the latest version.

     
    #3539
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.