+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, Database Name in Technical; Just a query really, do any schools name their SIMS database to anything other then "SIMS"?...
  1. #1
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0

    Database Name

    Just a query really, do any schools name their SIMS database to anything other then "SIMS"?

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Mine was sims2005 on a sims2005 instance! Then i moved to 2008, and it had to keep the name cos of how i migrated.
    Only at Easter did i manage to start afresh how i wanted:

    <sims server>\sims2008 as the instance
    dbname = sims.

    Now i can move that to any instance for ever and it will be named right.

    Ditto FMS it was called ccsfmssql - who thinks these up?!

  3. Thanks to vikpaw from:

    Rawns (20th June 2011)

  4. #3
    AyatollahPies's Avatar
    Join Date
    Jan 2008
    Location
    Earth
    Posts
    900
    Thank Post
    48
    Thanked 105 Times in 95 Posts
    Rep Power
    42
    Quote Originally Posted by Rawns View Post
    Just a query really, do any schools name their SIMS database to anything other then "SIMS"?
    Not come across it, but many fms database have different names, especially if the school has a childrens centre attached.

  5. Thanks to AyatollahPies from:

    Rawns (22nd June 2011)

  6. #4
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    10
    Our is now called SIMS. Similar to @vikpaw, ours was called SIMS2008, and the instance called SIMS. The name doesn't really matter as long as it's referenced correctly in the .ini files.

    @AyatollahPies is correct, I've come across many FMS DBs with names that describe their use.

  7. Thanks to NorthernSands from:

    Rawns (22nd June 2011)

  8. #5

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Reasons to name Database instance other than SIMS are:

    More than one Instance, now or in future.
    Easier to identify the instance if sent to Capita.

    If you are only having or likely to have one instance then SIMS is absolutely fine.
    As someone who supports many Databases and instances, easy identification is useful.

  9. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    However, it seems many default installations are poorly thought out in terms of what to call the db. The instance, can be anything, so long as you can identify it on your network. But the db is often called the same as the instance usually something like SIMS2005 That then gets migrated and isnt 2005 anymore, which is confusing.

    Sometimes you have something like simssvr\sims2005\sims2005 which is what we had in the past - crazy.

    then it goes to simssvr\sims2008\sims2005 . It's even more confusing when you come across someone that has their server called SIMS or sims2000 - it happens!

    @creese do you have any setups where you host multiples yourself? Do you have an instance per school and they all dbs are called sims, or one instance and the db name is unique..

    @jinnantonnixx has a hosted setup with loads of sims but, i think they have one instance.

  10. #7

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    We have several sites with multiple instances. Also some training machines and test machines with up to 6 instances. All on the same database.

    The Database itself is the least important name-wise, in my mind.

  11. #8
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    10
    We'll be hosting two SIMS DBs using this structure:

    <MIS-server>\SIMS2008BS\SIMS
    <MIS-server>\SIMS2008IS\SIMS

    Top one being for the British Stream, bottom the Indian Stream.

    Simples!
    Last edited by vikpaw; 23rd June 2011 at 10:30 AM.

  12. #9

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    I was forgetting the Centralised server we are running with about 12 instances, one DB.

  13. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by creese View Post
    I was forgetting the Centralised server we are running with about 12 instances, one DB.
    You mean DB name right...?

  14. #11

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,253
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Quote Originally Posted by vikpaw View Post
    You mean DB name right...?
    Rushed to post as I had to attend a dead or dying server.

    The central is MSSQL.SIMSSQL2008\MSSQL\school(1-12).mdf

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Database - where is it?
    By quietriot1983 in forum MIS Systems
    Replies: 32
    Last Post: 22nd March 2011, 06:21 PM
  2. Database
    By silver_hippo in forum Courses and Training
    Replies: 2
    Last Post: 6th November 2008, 09:11 AM
  3. EMBC - using a database
    By SpuffMonkey in forum Web Development
    Replies: 6
    Last Post: 9th November 2007, 06:36 PM
  4. HELP!!!! - Database
    By lalalalalalalalalalala in forum How do you do....it?
    Replies: 1
    Last Post: 21st March 2007, 09:03 PM
  5. Replies: 4
    Last Post: 28th February 2007, 09:37 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
  •