MIS Systems Thread, Database Name in Technical; Just a query really, do any schools name their SIMS database to anything other then "SIMS"?...
20th June 2011, 04:22 PM #1
Just a query really, do any schools name their SIMS database to anything other then "SIMS"?
20th June 2011, 04:39 PM #2
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:
\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?!
20th June 2011, 04:51 PM #3
Not come across it, but many fms database have different names, especially if the school has a childrens centre attached.
Originally Posted by Rawns
Thanks to AyatollahPies from:
22nd June 2011, 11:04 AM #4
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.
Thanks to NorthernSands from:
22nd June 2011, 11:14 AM #5
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.
22nd June 2011, 11:45 AM #6
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.
22nd June 2011, 11:49 AM #7
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.
22nd June 2011, 11:56 AM #8
We'll be hosting two SIMS DBs using this structure:
Top one being for the British Stream, bottom the Indian Stream.
Last edited by vikpaw; 23rd June 2011 at 10:30 AM.
22nd June 2011, 12:01 PM #9
I was forgetting the Centralised server we are running with about 12 instances, one DB.
22nd June 2011, 12:20 PM #10
You mean DB name right...?
Originally Posted by creese
22nd June 2011, 02:45 PM #11
Rushed to post as I had to attend a dead or dying server.
Originally Posted by vikpaw
The central is MSSQL.SIMSSQL2008\MSSQL\school(1-12).mdf
By quietriot1983 in forum MIS Systems
Last Post: 22nd March 2011, 06:21 PM
By silver_hippo in forum Courses and Training
Last Post: 6th November 2008, 09:11 AM
By SpuffMonkey in forum Web Development
Last Post: 9th November 2007, 06:36 PM
By lalalalalalalalalalala in forum How do you do....it?
Last Post: 21st March 2007, 09:03 PM
By sidewinder in forum Windows
Last Post: 28th February 2007, 09:37 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)