+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, SIMS SQL Server Table Documentation in Technical; Hi i am looking for any documentation anyone might have (homemade or otherwise) regarding the table structures of SIMS Sql ...
  1. #1

    Join Date
    Jun 2007
    Location
    St Marylebone School
    Posts
    13
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS SQL Server Table Documentation

    Hi

    i am looking for any documentation anyone might have (homemade or otherwise) regarding the table structures of SIMS Sql tables. I am doing some ugly hacks into it and this kind of information would be really useful. I would also be interested in anyone else who has gone down this route of integrating data straight from the tables.

    thanks

    pete

  2. #2

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    Altering the Sims.NET database directly causes your license to explode IIRC. You must use the provided API to interface with Sims.NET and it's database.

  3. #3

    Join Date
    Jun 2007
    Location
    St Marylebone School
    Posts
    13
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I am not altering it, i am merely reading from it. plus i have taken a copy of the mdb and am testing everything on there. this is ok right?

  4. #4

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    Nope, you have to use the APIs.

  5. #5

    Join Date
    Jun 2007
    Location
    St Marylebone School
    Posts
    13
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I don't understand. why would it matter if i corrupted a copy of a database? plus there is very little corruption you can do with read only functions.

  6. #6

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    Read your EULA for SIMS.Net.

  7. #7

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,528
    Thank Post
    513
    Thanked 2,406 Times in 1,862 Posts
    Blog Entries
    24
    Rep Power
    822
    It is part of the license agreement for SIMS.net that you must use the APIs to access the database. If you don't, you are in breach of the agreement.

    You have to make use of the commandreporter.exe application and run reports instead.

  8. #8

    Join Date
    Jun 2007
    Location
    St Marylebone School
    Posts
    13
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    ok brilliant. thanks very much. will look into this. i assume you don't have any info on table structures though?

    thanks

    pete

SHARE:
+ Post New Thread

Similar Threads

  1. server documentation
    By plexer in forum Wired Networks
    Replies: 9
    Last Post: 13th April 2012, 10:36 PM
  2. SIMS 3rd Party Access Documentation
    By peterteckhokgoh in forum MIS Systems
    Replies: 17
    Last Post: 8th August 2010, 03:32 AM
  3. Time table
    By thegrassisgreener in forum General Chat
    Replies: 35
    Last Post: 27th November 2007, 04:39 PM
  4. SIMS: Third Party access SDK documentation
    By peterteckhokgoh in forum MIS Systems
    Replies: 1
    Last Post: 14th August 2007, 10:50 AM
  5. Sims Documentation
    By Pear in forum MIS Systems
    Replies: 16
    Last Post: 23rd January 2006, 02:47 PM

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
  •